Random selection of names with no duplicates and ignoring a predetermined name list

Please Login or Register  to view this content.

Found the funtion online a while back, never thought I'd end up using it.

After this code runs, you can then use an index formula to get your names.

It's a start, ignoring names on another list... that's the difficult part.

You could have your list of 300 reduced by the names to ignore, and then adjust the random number parameters in the macro.

Hi iain.excel and welcome to the forum.

Find an example workbook with what I think is the answer you want. Look at the formulas in Col B.

You will need to press F9 to get a new set of random numbers and then sort the table by col B (small to large). Take the top 50 names and that is your answer.