Selecting one every four other rows

[Guest]

Another need from a helpless analyst.

I need to be able to select rows from a large database. I need to get the
row 2, then row 5 and so on. I need to do this for a random sorting for
surveys. Of course if anyone has a way to randomly select rows it'd be even
better

Regards
Juan Eduardo

 

[Tom Ogilvy]

in the next available column put in the formula

=rand()

then drag fill down the column. Sort the data on this column, then select
the first "N" rows for your sample.