There are a few other threads like this already, hoping to gain a bit more clarification in explaining why it works, not just a forumlas. I do MUCH better when I understand how it works.
This is my goal - These are starting in cell A16 going down.
=‘Database'!B6
=‘Database'!B11
=‘Database'!B16
=‘Database'!B21
When dragging A16/A17 down I get thie
=‘Database'!B6
=‘Database'!B11
=‘Database'!B8
=‘Database'!B13
I know I need to use offset, something similar to this:
=(OFFSET(‘Database'!B6,(ROWS(A$1:A1)-1)*2,0))
but i'm trying to figure out how to do it. (ROWS(A$1:A1)-1)*2,0)) confuses me. I partially stole this from another post so I'm trying to figure out what I need to put to make this applicable to my sheet.
Bookmarks