Hello, I have a question, I have 5 columns, and in each row of the column there is a given name as in the attachment.
What to do that in column G, or some other one next, fomula showed me which cell has the most characters, or most character ">" and showed or indexed it?
So something like: indicate which cell has the most characters, or character ">" and show it.
[Solved] Which cell has the most characters? formula?
-
- Posts: 55
- Joined: Thu Dec 13, 2018 10:27 am
[Solved] Which cell has the most characters? formula?
- Attachments
-
- kategorie chwilowy.ods
- (14.04 KiB) Downloaded 72 times
Last edited by Hagar Delest on Thu Feb 20, 2020 12:20 am, edited 1 time in total.
Reason: tagged solved
Reason: tagged solved
OpenOffice 4.1.6 Windows 10
Re: Which cell has the most characters? formula?
There is a fundamental problem with your question: The ONE cell "with the most characters" will simply not exist if there are more than one cells containing the same maximum number of characters.
Acceptably simple means (formulas based on standard functions) will only return the first cell containing the maximum found. There may be more to the right (if matched in a row) or to the bottom (if matched in a column).
If more complexity is accepted, you still need to consider that a cell only can return ONE result. Returning more than one match in a cell would require to create something like a list in text form. AOO does not provide a standard function for this purpose.
Also see attachment. Errors and the "second-match-issue" are marked there by coloring.
Acceptably simple means (formulas based on standard functions) will only return the first cell containing the maximum found. There may be more to the right (if matched in a row) or to the bottom (if matched in a column).
If more complexity is accepted, you still need to consider that a cell only can return ONE result. Returning more than one match in a cell would require to create something like a list in text form. AOO does not provide a standard function for this purpose.
Also see attachment. Errors and the "second-match-issue" are marked there by coloring.
- Attachments
-
- aoo101140findCellOfMaxTextlengthAndSo_1.ods
- (19.57 KiB) Downloaded 67 times
On Windows 10: LibreOffice 24.2 (new numbering) and older versions, PortableOpenOffice 4.1.7 and older, StarOffice 5.2
---
Lupp from München
---
Lupp from München
-
- Posts: 55
- Joined: Thu Dec 13, 2018 10:27 am
Re: Which cell has the most characters? formula?
ok, is fine, formula can show me first finded row.
But now how i can index it? formuła show me d4 but i need cell content.
But now how i can index it? formuła show me d4 but i need cell content.
OpenOffice 4.1.6 Windows 10
Re: Which cell has the most characters? formula?
Use the INDEX() functiondawidek990 wrote:... how i can index it? ...
Re: Which cell has the most characters? formula?
Try the function INDIRECT().formuła show me d4 but i need cell content.
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: Which cell has the most characters? formula?
Omitting the ADDRESS() function and instead passing the MATCH() result to the INDEX() function as the column index should be rather efficient.
I only used ADDRESS() in the preliminary solution to ease the comparison with what the OQer already had entered by hand.
I only used ADDRESS() in the preliminary solution to ease the comparison with what the OQer already had entered by hand.
- Attachments
-
- aoo101140findCellOfMaxTextlengthAndSo_2.ods
- (19.87 KiB) Downloaded 61 times
On Windows 10: LibreOffice 24.2 (new numbering) and older versions, PortableOpenOffice 4.1.7 and older, StarOffice 5.2
---
Lupp from München
---
Lupp from München
-
- Posts: 55
- Joined: Thu Dec 13, 2018 10:27 am
Re: Which cell has the most characters? formula?
INDIRECT() is the best and most simple function ;]
is working, thank you very much ;]
is working, thank you very much ;]
OpenOffice 4.1.6 Windows 10