Random
Hi
I have a spreadsheet that has a cloumn of names that varies in size each week. From that I need to randomly select a number of names depending on the sixe of the list.
They can not be duplicated. I have done =INDEX($B$2:$B$282,INT(RANDBETWEEN(2,282))) which does give names, but i think I need a macro for entering the size of the range and the number of results needed.Any help would be great. Thanks
Recent comments
6 years 7 weeks ago
6 years 45 weeks ago
7 years 5 weeks ago
7 years 8 weeks ago
7 years 9 weeks ago
7 years 14 weeks ago
7 years 22 weeks ago
7 years 23 weeks ago
7 years 23 weeks ago
7 years 23 weeks ago