Thread: Is there a way to place every 5th line in a cell?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default 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
Reply With QuoteReply With Quote