View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bj bj is offline
external usenet poster
 
Posts: 1,397
Default how to identify unique list of 200 random entries from a list of 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


"tjb" wrote:

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