How Do You Create a Random Schedule?

Growth Trends for Related Jobs

careertrend article image

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