You’ve got 10 entrants for a running race and need to decide the lanes for each. They’re a suspicious bunch, so you need to assign lanes without being accused of bias. What do you do? Use a spreadsheet formula, of course!
In either program, enter the name of each runner in column A, then the numbers 1 to 10 in column B. To add the random numbers that will decide the lane order, enter =RAND() in C1, then copy this formula from cells C2 to C10. We’ll now use these random numbers, which are all between 0 and 1, to re-order column B. Using your mouse, select columns B and C (make sure you leave column A unselected).
In Excel, select the Data tab at the top, click Sort. Next,…
