How Do You Create a Random Schedule?

How Do You Create a Random Schedule?
Written By
Brenda Barron
Brenda Barron
Dec 3, 2010
1 minute read

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.”

References

Photo Credits

anyaberkut/iStock/GettyImages

Brenda Barron

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…

Sponsored
Career Trend Logo

Career Trend is the go-to guide for readers navigating their careers, offering diverse and credible content for those looking to achieve professional success.

Property of TechnologyAdvice. © 2026 TechnologyAdvice. All Rights Reserved

Advertiser Disclosure: Some of the products that appear on this site are from companies from which TechnologyAdvice receives compensation. This compensation may impact how and where products appear on this site including, for example, the order in which they appear. TechnologyAdvice does not include all companies or all types of products available in the marketplace.