G Guest Jul 5, 2007 #1 How do I get a list of 200 unique random entries from a list of 3100 unique entries?
L L. Howard Kittle Jul 5, 2007 #2 In a helper column next to your entries, enter =Rand() and fill down. Then sort by the random column and take the top 200. HTH Regards, Howard
In a helper column next to your entries, enter =Rand() and fill down. Then sort by the random column and take the top 200. HTH Regards, Howard
G Guest Jul 5, 2007 #3 the simplest way is to use a helper column next to the data set, enter =rand() and paste to the bottom of the data. you can either sort the two columns beased on the helper column and use just the top 200 values
the simplest way is to use a helper column next to the data set, enter =rand() and paste to the bottom of the data. you can either sort the two columns beased on the helper column and use just the top 200 values
B Bernd P Aug 13, 2007 #4 Hello, I suggest to use my UDF UniqRandInt: http://www.sulprobil.com/html/uniqrandint.html Regards, Bernd
Hello, I suggest to use my UDF UniqRandInt: http://www.sulprobil.com/html/uniqrandint.html Regards, Bernd
