Random select names from a list (w/some duplicates) to a new list without duplicates

  • I have a sheet containing 40 names in a column (some are duplicated) and need to generate a random list of 10 names with no duplicates in another column.

  • Hello! try this code:

    You can change these variables per your specific needs:
    NameColumn = 1 'Change this if your names are not in column A
    FirstNameRow = 2 'Change this if your first name does not start in row 2 (1 would be the column header)
    NewColumn = 5 'Change this if you want to change the column of 10 names from column E to a different colulmn
    NumberOfNames = 10 '10 Names in new list

    Let me know if you have any questions.


Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!