Select random name from a list with Kutools for Excel Then you will get random names from a specified list without duplicates as the above screenshot shown. Select the result cell and then drag its Auto Fill Handle over the cells to display the random names. Select a blank cell to ouput the random name (here I select C2), enter the below formula into it and press the Enter key. Then select the result cell and drag its Auto Fill Handle over the helper column cells to get the other results.Ģ. Select a blank cell next to the first name of the list (here I select B2), enter the below formula into it and press the Enter key. Select random names from a list without duplicatesĪs the above formula may cause duplicate random names in the result, in this section, we will show you two formulas to help selecting random names from a list without duplicates in Excel.ġ. The random name will be changed automatically every time you refresh the worksheet.
0 kommentar(er)
