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

"tjb" wrote in message
...
How do I get a list of 200 unique random entries from a list of 3100
unique
entries?


Reply With QuoteReply With Quote