| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| LOOKUP and return the column heading for IF/THEN return for False | Excel Discussion (Misc queries) | |||
| how do i insert words into a column without erasing the words | Excel Discussion (Misc queries) | |||
| check if reference exists, then return its value or return 0 | Excel Worksheet Functions | |||
| need IF function to return 0 if it finds a one out of three words | Excel Worksheet Functions | |||
| more words | New Users to Excel | |||
Hybrid Mode
