hi. i just inherited a goliath workbook with four interconnected
spreadsheets that my old boss had used to manage certain aspects of our
company's contract accounting.
one of the functions that he created reads
"=+OFFSET(Detail!$F$1,D22-1,$F$11-1,1,1)". this results in a number that is
important to my task at hand, so i need to know where it came from. knowing
that i am not particularly excel-savvy, can someone tell me what this
expression means? fyi, "detail" is the name of another page of the workbook
from the one where this text is found.
in case it matters, i did look at cell F1 of the "detail" page, but it is
simply a date, and not a related one at that. i wish i knew what the dollar
signs mean.