View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
bj bj is offline
external usenet poster
 
Posts: 1,397
Default Picking specific rows from database

in column K enter = mod(row(),8)
use auto filter and select 1

"Buzz Sawyer" wrote:

I need to pick rows 1,9,17, etc. from 2,898 rows with columns A tru I.

This will give me a table of Names & Phone Numbers I can use with a phone
dialer.

Thanks for the help.
--
Buzz Sawyer