Hello folks. I have a formula like this in B6
=OFFSET(RAW!$C9,,ROWS(B$6:C6)-1)
What I want is to increment the reference RAW!$C9 to add 90 so it would be reference RAW!$C99 in C6, RAW!$C189 in D6 and so on. How to do it while inside the OFFSET formula since I'm using it to get the data from RAW sheet?
Example (I did this manually)
from
1.PNG
to
2.PNG
Bookmarks