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?
|