One option:

Insert a new column next to your data.
Enter the formula: =Rand()
Copy the formula down for all data
Sort your data by the new column

You can then look at the first 5 lines, or 10, or 100... whatever sample
size you need.

HTH,
Elkar


"random selection of data" wrote:

how do we select a small sample of data randomly froma given set of large
data in excel