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?