Return the words in every 5th row

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to return whatever is in every 5th row in the cell that you
are in? I tried =INDIRECT("H"&ROW()*5) but it is not working.
 
What do you mean by "it is not working"? If you want the group to help you
to find your error you will need to describe the symptoms in more detail.
With that formula, the cell in row 1 will show the contents of cell H5, the
cell in row 2 will show the contents of H10, the cell in row 3 will show
H15, and so on.
What are you trying to achieve, and what is the formula showing you?
 
I mean that it is not returning the value in every 5th cell. I am trying to
say look in column H and return whatever is in every 5th row under column H.
 
See the answers in your other post.

It's best to stick to your original, so all can see what's already been
suggested and not duplicate efforts.
 
Back
Top