3 Replies Latest reply on Nov 13, 2018 1:00 AM by sravani adapa

    Random Names

    Syeda Rashid

      Hi I have Data source with about 800+ names, and these names repeat within rows. I am trying to get a random sample of 40 names from this list. If i were to number each row and then do the RANDOM function, it likely wouldn't work because many times would show up 2-3-4-5 times maybe.

       

      Is there a way to pick up 40 unique rows from this list.

       

      Thanks in advance for your help!