i need help to create a formula copying a formula from cell a5 to a20 but i want the result to be 1 cell lower from a5's result
i need help to create a formula copying a formula from cell a5 to a20 but i want the result to be 1 cell lower from a5's result
Your heading doesn't tie in with what you have written below it in the main text. Please explain your requirements more clearly.
Pete
oops sorry. typo error. what i meant was copying a formula from cell a5 to a13 but the result would be 1 cell lower from a5's.
What formula do you have in cell A5, and how do you want it to change in A13?
Pete
hi Pete,
Here it is. my formula in cell a5 is "=Sheet1!A1". I want to copy it to cell a13 but the result would be equivalent to "=sheet1!A2".
Put this formula in A5:
=INDEX(Sheet1!A:A,INT((ROWS($1:1)-1)/8)+1)
Then copy it into A13, A21, A29 etc.
Hope this helps.
Pete
thanks Pete. It really helped alot.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks