How Do You Create a Random Schedule?

Growth Trends for Related Jobs

Planning out a work schedule can be a pain, especially when delegating tasks between workers on a regular basis. Thankfully, you can create a random schedule that orders tasks for you, so you don't have to deal with the headache of the meticulous planning yourself or the frustration of being blamed of poor planning.

Start your copy of Microsoft Excel. In the first column, list out the tasks that you want to be randomly scheduled. List out as many items as you want, keeping them all in the same column.

Select the column to the right of your task column and enter the formula “=rand()”. Enter this into each of the cells in this column that has a task in the adjacent task column.

Highlight all of the task and formula data with your mouse. Click on “Data” from the menu bar and select “Sort.”

About the Author

Brenda Barron is a writer, editor and researcher based in Southern California. She has worked as a writer since 2004, with work appearing in online and print publications such as BabyZone, "Cat Fancy" and "ePregnancy." She holds a Bachelor of Arts in English literature from California State University, Long Beach.

Cite this Article