I now have a number of long columns all of equal length, all of which, row by row, are getting steadily longer.
What I need to know is how to, at any given time, have a row that contains the contents of the final cell in each column that is not blank.
For example, say there are 26 columns of information (Columns A-Z), and each column has 100 cells containing information, and the final row that has any information is row 100. I'd need a row 26 cells (or columns) long, with each cell containing whatever row 100 has in it.
Then when row 101 is filled, the row would then have whatever row 101 had in it.
I couldn't find a function that could do this (but that doesn't necessarily mean there isn't one).
Know how to do this?
Thanks.
[Solved] Find the contents of last used cell in a column?
[Solved] Find the contents of last used cell in a column?
Last edited by imdumb on Sat Oct 14, 2017 7:29 pm, edited 1 time in total.
open office 4.1.2, windows 7
- JohnSUN-Pensioner
- Volunteer
- Posts: 876
- Joined: Fri Jan 14, 2011 1:21 pm
- Location: Kyiv, Ukraine
Re: How do I find the contents of the last cell in a column?
It took only nine years old, and again asked about it
Try just use GetLastUsedRow from standard library Tools - one of example of using - here (6 years ago)
Try just use GetLastUsedRow from standard library Tools - one of example of using - here (6 years ago)
I may not have a lot to give but what I got I'll give to you...
Apache OpenOffice 4.1.5, LibreOffice 6.4.4.2 (x64) on Windows 7
If you think that I did not answer your question, make allowances for my imperfect English
Apache OpenOffice 4.1.5, LibreOffice 6.4.4.2 (x64) on Windows 7
If you think that I did not answer your question, make allowances for my imperfect English
Re: How do I find the contents of the last cell in a column?
Thanks for your efforts, unfortunately I couldn't make your suggestion work.
That certainly doesn't mean you gave advice that doesn't work.
A better explanation? Well, note my name
But here's a different solution:
Find the last number used in column A:
............A
1...........1
2...........2
3...........3
4...........=INDEX(A1:A3;COUNTA(A1:A3))
It gives a "3". Just what I need!
That certainly doesn't mean you gave advice that doesn't work.
A better explanation? Well, note my name
But here's a different solution:
Find the last number used in column A:
............A
1...........1
2...........2
3...........3
4...........=INDEX(A1:A3;COUNTA(A1:A3))
It gives a "3". Just what I need!
open office 4.1.2, windows 7
Re: (SOLVED) Find the contents of last used cell in a column
imdumb,
your solution works well, when your data is continous, without empty cells inside the used cellrange.
The value of the last used cell on a column and the value indexed to the count of the data values maybe will be in different place.
your solution works well, when your data is continous, without empty cells inside the used cellrange.
The value of the last used cell on a column and the value indexed to the count of the data values maybe will be in different place.
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
Re: (SOLVED) Find the contents of last used cell in a column
=MAX(ISNUMBER(A1:A1048576)*ROW(A1:A1048576)) [Ctrl+Shift+Enter]
=MAX(ISTEXT(A1:A1048576)*ROW(A1:A1048576)) [Ctrl+Shift+Enter]
=MAX(NOT(ISBLANK(A1:A1048576))*ROW(A1:A1048576)) [Ctrl+Shift+Enter]
=MAX(ISTEXT(A1:A1048576)*ROW(A1:A1048576)) [Ctrl+Shift+Enter]
=MAX(NOT(ISBLANK(A1:A1048576))*ROW(A1:A1048576)) [Ctrl+Shift+Enter]
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice