Forum Discussion
Vlookup and RandBetween Function
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 n...
Are you able to put the random number next to each name in the list?
You could then pull that data into Pivot Table and do a Top 5
Or if you have Excel 365 you could use the SORTBY function to return a sorted list and then reference the first 5 rows of that in another formula.
If you have 365 I'll attach an example later.
You could then pull that data into Pivot Table and do a Top 5
Or if you have Excel 365 you could use the SORTBY function to return a sorted list and then reference the first 5 rows of that in another formula.
If you have 365 I'll attach an example later.
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.
- Any chance you can upload a sample file with an example?
