Excel Row sampling

I have an excel table with many number of rows.

I would like to take a random sample of say 100 rows and hide the rest, say display 1 row per 500 rows or completely random selection of the entire worksheet works also.

Recent Questions...