| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
OFFSET COLUMN() ROW() - what does this mean?
I have a formula which I'm trying to get my head around
OFFSET('Daily Datasheet'!$B$1,ROW()-ROW($AL$4)-5,$AM$3+COLUMN()-COLUMN($AL$4)) Can someone explain what each part means? I get what OFFSET does, just not sure how ROW and COLUMN fit into it.. Thanks.. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert column with offset | Excel Discussion (Misc queries) | |||
| Countif from an offset column | Excel Worksheet Functions | |||
| offset 1 row and return to first column | Excel Discussion (Misc queries) | |||
| ???? =offset(ADDRESS(ROW(),COLUMN()),1,1,1,1) | Excel Worksheet Functions | |||
| offset every nth column | Excel Worksheet Functions | |||
Threaded Mode
