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

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

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

In an unused column enter:

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

you will get H5, H10, H15,....
--
Gary's Student
gsnu200707


"Terri" wrote:

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

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

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!
================================================== ===


"Terri" wrote in message
...
Is there a formula that you can use to look in say column H, and return what
is in every 5th row?
--
Terri
Amos Pewter