Just another nifty way at approaching the same problem in a different tool. There’s a similar template in the Coda gallery which generates a random list of teams of players based on the number of teams and players you have. Sometime it’s just easier to do it in a spreadsheet because all our data is there, but constantly question if the tool you are using is the right one for the job. There are hundreds of random list generator apps that may be built specifically for your industry be it education or hospitality. So in column E, we just do a VLOOKUP using column D as our lookup value and columns A:B as our lookup table to get the name associated with the random number in column D:Ī caveat I point out at the end of this episode is that while you can do this random list of names generator in Excel or Google Sheets, a spreadsheet may not be the best tool for the job. What does this column of sorted random numbers do for us? Well, we know that each random number in this sorted column corresponds to one of the numbers in column A where we generated the random number. The formula kind of “spills” down for you as your list grows so you don’t have to worry about dragging the formula down until the last row in your data set. This is a relatively new function in Excel since it kind of acts like dynamic array formulas or array-entered formulas. ![]() There are different tools online that claim to generate random names but they have different. The nice thing about the SORT function is that it automatically fills the formula down to the bottom of your data set. Random Name Generator is an online tool that generates a list of random names for different purposes. You can also put 0 to indicate false which is what I did in this example to sort in descending order. ![]() The SORT function takes in a range of cells as the first parameter, the sort index as the 2nd (which is just the number column we ant to sort on, column #1), and then true or false for sorting in ascending or descending order.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |