Рет қаралды 11,206
How to pick a random name or item from a very long list of names or another database list. Use formulas and functions to pick a random item from a very long list.
If your list has over 30,000 rows and you need to select RANDOM names of customers, employees, or items, you need to make sure you do so objectively. That is where the RANDBETWEEN function comes to play. Additionally, you can also use the COUNTA function to count the rows, which may be updated frequently.
Finally, the INDEX function will help you pull the randomized row information (such as the data item selected) and the VLOOKUP function will pull additional data for the winning name or item (such as phone numbers, dob, email addresses or anything else).
-------LINKS---------- --
All the Google Sheets shortcuts for Mac & PC:
support.google...
Google Sheet List of Functions:
support.google...
#akaakidesign #akistepinska