View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default 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?