Generate Unique Random Names

  • Hello,
    I am re-posting this with a better explanation. I have 4 columns (A-D) of golfers names (including blanks). I need to choose a random name from Column A, 1 from B, etc. to create foursomes without repeating a name. Each group must be unique each time I use it. These could go into Columns E-H. Please help!!!


    Many Thanks,
    drltr6