Thread: Create a new sheet containing random sampler 200 rows over 2000
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Thierry Sophia-Antipolis[_2_] Thierry Sophia-Antipolis[_2_] is offline
external usenet poster
  
Posts: 1
Default Create a new sheet containing random sampler 200 rows over 2000
Thanks to the forum I have found the solution.
Create a new column, fill it with =RAND() then sort the column with Top 200
Items.

"Thierry Sophia-Antipolis" wrote:

Based on a sheet containing 2260 rows I need to create a new sheet that would
select randomly 200 rows.
Reply With QuoteReply With Quote