ExcelBanter - Random Samples

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Random Samples (https://www.excelbanter.com/excel-discussion-misc-queries/253243-random-samples.html)

random

Random Samples

I am interested in pulling a random sample of a excel spreadsheep. The
spreadsheet is populated with 132,000 rows.

Bob I

Random Samples

In a helper column, put =Rand(), sort the sheet on that column, pick the
desired number of rows as the sample.

random wrote:
I am interested in pulling a random sample of a excel spreadsheep. The
spreadsheet is populated with 132,000 rows.

All times are GMT +1. The time now is 04:08 PM.