Offset Help
 

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?

Offset Help
 

=INDEX($A$1:$A$100,SMALL(IF(MOD($A$1:$A$100,6)=0,R OW(INDIRECT("1:"&ROWS($A$1:$A$100)))),ROWS($1:1)))

ctrl+shift+enter, not just enter
copy all the way down until you see 0


"Hunter" wrote:

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?

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?

Offset Help
 

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?

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?

Offset Help
 

Thank you very much.

"Roger Govier" wrote:

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?