![]() ![]() For example, weve created a named range called orders that refers to. If you are unsure of how to setup a named range in your spreadsheet, read our tutorial on Adding a Named Range. A named range is a descriptive name for a collection of cells or range in a worksheet. This gets rid of the random numbers, as you no longer need them. You can also use a named range in the DAVERAGE function. Select the column again by clicking on the initial row letter and then click Delete.Excel will offer to expand the selection (so you’ll actually sort the names as well). Click on the ‘Sort & Filter’ button on the Home tab and choose ‘Sort Smallest To Largest’.Select the column filled with random numbers by clicking on the initial row letter at the top. ![]() This will place a different random number in each cell next to the relevant names. Fill that formula to the end of your list by holding Shift, pressing the down key until you’ve selected to the row where your list ends, and typing Control-D to auto-fill.(This generates a random number between 0 and 1.) In the first cell in that column, enter the formula =RAND().(Click the Insert drop-down on the Home tab and choose ‘Insert Sheet Column’.) Click NEW LIST at the top of the Custom lists box to create a new custom list. You will see a list of all your lists in the Custom Lists editor. Select NEW LIST in the 'Custom lists' box. Then, click Preferences and Custom Lists, respectively. Insert a new column on the list next to your list of names. For 'Excel for Mac', click the Excel menu in the upper-left corner.Assuming your list of names is already in Excel, follow these steps. This probably isn’t the most sophisticated way to do it, but it works. Sorting names randomly can be useful (for instance if you’re assigning tasks or picking a competition winner). ![]()
0 Comments
Leave a Reply. |