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.
It's best to stick to your original, so all can see what's already been
suggested and not duplicate efforts.
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.
