Thread: Offset Help
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default Offset Help

This will return the values from A6, A12, A18, A24, etc:

=INDEX(A:A,ROWS($1:1)*6)

Copy down as needed.

Biff

"Hunter" wrote in message
...
I have a list of data. I want to pull every 6th number out of the list. I
can get it to work once by using the offset function. However, I can not
get
it to work after that. Any suggestions?