Return the words in every 5th row
 

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.
--
Terri
Amos Pewter

Return the words in every 5th row
 

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?
--
David Biddulph

"Terri" wrote in message
...
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.
--
Terri
Amos Pewter

Return the words in every 5th row
 

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.
--
Terri
Amos Pewter


"Terri" wrote:

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.
--
Terri
Amos Pewter

Return the words in every 5th row
 

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.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Terri" wrote in message
...
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.
--
Terri
Amos Pewter


"Terri" wrote:

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.
--
Terri
Amos Pewter