Offset Help
Hi
Then amend Biff's formula to
=INDEX(R:R,8+ROWS($1:1)*6)
--
Regards
Roger Govier
"Hunter" wrote in message
...
That works great! Now what if my data starts on say R14 and I want
every 6th
number?
"T. Valko" wrote:
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?
|