I own a long row of facts contained by Column A.
The type of notes repeats itself every 10th row. What I'd close to to do is create a column B that have a formula that returns me the contents within:
Cell A2
Cell A12
Cell A22
Cell A32
Cell A42
Cell A52
But contained by column B, they would be returned one cell at a time. So essentially, cell B2 would own A2. Cell B3 would own A12. Cell B4 would hold A22, and so on...
Obviously, a formula of "=B2+10" will return the contents of B2 plus the numeric 10, which is not what I'm after.
Can someone permit me know what the formula is for me to do this?
Answers: Type within B1
=INDIRECT("A"&(ROW()*10)-8)
Then copy it down…
Note :- Depending on the place where on earth you put this formula surrounded by the excel sheet, you'll hold to do some changes
Jeff-
if i infer.
the formulas would be:
cell B2: =A2
cell B2: =A12
etc.
its that assured...
hope this is what you are looking for.
appropriate luck :)
=INDIRECT("A"&ROW()*10+2)
=INDIRECT("A"&ROW()*10+2)
=INDIRECT("A"&ROW()*10+2)
=INDIRECT("A"&ROW()*10+2)
Adjust as required