Selecting one every four other rows
 

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 :D

Regards
Juan Eduardo

Selecting one every four other rows
 

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.

--
Regards,
Tom Ogilvy

"Juan Eduardo Gorigoitía"
wrote in message ...
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 :D

Regards
Juan Eduardo