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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy Every 5th Row 6
add or subtract every 5th column 2
Is there a way to place every 5th line in a cell? 2
Copying formulas 2
Determine cell address of last entry in a row 2
Keep cell position in a formula after data is deleted 2
Need help with a formula, please!!! 2
Lenovo recalls 80,000 5th Gen ThinkPad X1 Carbon laptops 0

Back
Top