Is there a way to place every 5th line in a cell?

T

Terri

Is there a formula that you can use to look in say column H, and return what
is in every 5th row?
 
G

Gary''s Student

In an unused column enter:

=INDIRECT("H"&ROW()*5)
and copy down

you will get H5, H10, H15,....
 
R

RagDyeR

To display row 1, 6, 11, ... etc.,
Try this *anywhere* on the Sheet:
=INDEX(H:H,5*ROWS($1:1)-4)

To display Row 5, 10, 15, ...etc.
Try this *anywhere* on the Sheet:
=INDEX(H:H,5*ROWS($1:1))

And copy down as needed.
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================


Is there a formula that you can use to look in say column H, and return what
is in every 5th row?
 
Top