Ask Your Question
0

Find last text data/cell [closed]

asked 2014-02-11 21:38:27 +0200

risker gravatar image

updated 2015-09-12 21:09:01 +0200

Alex Kemp gravatar image

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

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-19 10:43:15.276158

1 Answer

Sort by » oldest newest most voted
0

answered 2014-02-12 01:49:11 +0200

m.a.riosv gravatar image

updated 2014-02-13 01:06:55 +0200

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

edit flag offensive delete link more

Comments

Could you provide the offset function as-well? I have limited knowledge sorry.

risker gravatar imagerisker ( 2014-02-12 03:58:32 +0200 )edit

Question Tools

1 follower

Stats

Asked: 2014-02-11 21:38:27 +0200

Seen: 1,324 times

Last updated: Feb 13 '14