How can I choose every nth name in a spreadsheet?
Add a helper column with a formula of
=ROW()=INT(ROW()/n)*n
and copy down.
Filter on the TRUE values
--
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"Rechnem" wrote in message
...
I need to take a random sample of names from a spreadsheet. I would like to
choose every Nth name in the sheet. Does anyone know how to do that?
|