If you have a list of entries to pick from in Excel 2013, use the Rand() feature to create a random number beside each entry. Sorting the list by this random number scrambles the data, so there's ...

If you select the actual Table, Excel will use a longer version ... Simply change the value in D2 to change the number of names in the random list. INDEX() identifies the values to use in the ...