ExcelBanter - How could I get a random sample from an Excel Sheet

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How could I get a random sample from an Excel Sheet (https://www.excelbanter.com/excel-worksheet-functions/134047-how-could-i-get-random-sample-excel-sheet.html)

SAZFFXCTY

How could I get a random sample from an Excel Sheet

I am trying to create a sample from an excel report which contains about 3000
records. I would like to pick certain fields from this report and create a
separate file for about 10% of the records. Is there a way that I will be
able to create this kind of sample from the data.

Any help will be appreciated.

Thanks

Syed Zaman

All times are GMT +1. The time now is 10:18 AM.