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
5 years 6 weeks ago
5 years 44 weeks ago
6 years 4 weeks ago
6 years 7 weeks ago
6 years 8 weeks ago
6 years 13 weeks ago
6 years 21 weeks ago
6 years 22 weeks ago
6 years 22 weeks ago
6 years 22 weeks ago