Hey, I want to get the first ID & the last ID in column A but I want it to automatically find the last cell then format it like;
A1 - A*
EG: 2200 - 2211
I’m using LibreOffice Calc 4.0.4.2
To know the minimum/maximum row with data, arrays like:
=MIN(IF(ISBLANK(A$1:A$9999);9999;ROW(A$1:A$9999)))
=MAX(IF(ISBLANK(A$1:A$9999);0;ROW(A$1:A$9999)))
must work (To put the formula in the cell use Ctrl+Enter not only Enter)
to compose an usable address with the above results, you can use the functions:
OFFSET()
INDIRECT()
Edited 2014-02-13
Sample file on how create the range with both functions to use as source for other functions.
Sample_OFFSET_INDIRECT.ods
Learn always need a bit of effort, please take a quick read into the inner help and documentation: Calc documentation
Could you provide the offset function as-well? I have limited knowledge sorry.