how to identify unique list of 200 random entries from a list of 3

G

Guest

How do I get a list of 200 unique random entries from a list of 3100 unique
entries?
 
L

L. Howard Kittle

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unique records formula & zero entries 9
Unique Records 3
Array formula for unique entries 4
Counting Unique 1
random numbers 3
return unique data from a list 4
In 2 Excel worksheets, I am trying to eliminate duplicate entries 2
summary 1

Top