Hi,

the ROWS function is well-documented in XL and... Google is your friend
!

pcor;340564 Wrote:
Thanks. It worked very well. BUT...will you please exxplain what that
is
REALLY doing. I think I understand all but the ROWS($!:1) got me
confused.
Thansk again


"Ragdyer" wrote:

On Sheet6, enter this in B1:
=Sheet2!I1

And in B2 enter this:
=INDEX(Sheet2!I:I,7*ROWS($1:1))
and copy down as needed.
--
HTH,

RD


---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may
benefit !

---------------------------------------------------------------------------
"pcor" wrote in message
...
I have some data in sheet 2 in col I.
the data I want to capture is spaced by 7 spaces all the ay down:
EX:
I have data in sheet 2 col I row 1 ,7,14,21 etc

I would like to show the data in Sheet 2 to Sheet 6 col B row
1,2,3,4, etc
thanks




--
Pecoflyer

Cheers -
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=95134