There are a few different ways that you can select random names in Excel. One way is to use the RAND function. The RAND function will return a random number between 0 and 1. You can use this function to generate a list of random numbers, and then use those numbers to select a random name from a list.

Another way to select random names in Excel is to use the RANDBETWEEN function. This function will return a random number between two numbers that you specify. You can use this function to generate a list of random numbers, and then use those numbers to select a random name from a list.

You can also use the INDEX and MATCH functions to select random names from a list. The INDEX function will return the value at a given index in a list. The MATCH function will return the index of a given value in a list. You can use these functions together to select a random name from a list by matching a random number to an index in the list.

Finally, you can use the VLOOKUP function to select random names from a list. The VLOOKUP function will look up a value in a table or range of cells. You can use this function to look up a randomly generated number in a list of names, and then return the name that is associated with that number.