Oct 27 2020 04:35 PM
Hello All,
I am trying to generate a list of 6 unique names from a list of names with a number value assigned to them. However, When doing the below function I am getting multiples of the same name. I.E : John, John, David, Smith, Dustin, Dustin.
=VLOOKUP(RANDBETWEEN(1,$J$2),$A:D,4,TRUE)
Is there any way I can use this code to pick a random name from my list and the second name be a random name from the same list and if it selects a name that has been used before it selects a different name?
This would be helpful.
Oct 27 2020 05:10 PM
Oct 27 2020 05:30 PM
@Wyn Hopkins The names are associated with a group of numbers such as name 1 is any number from 1-71 and there are several names with several different numbers values for each name, Which makes this a little harder. I want the second name to take a random number and if it generates the same as the first name it selects another random number to get a different name.
Oct 28 2020 01:17 AM