Find last text data/cell

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

To know the minimum/maximum row with data, arrays like:



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:

Edited 2014-02-13
Sample file on how create the range with both functions to use as source for other functions.

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.