What is the longest cell

authormessage
Cindy_2308
guest


Posted:
11 Feb 2014, 12:46
First name:

       Version: Office XP (2002)

Hello everybody,

maybe someone has an idea:
I have a data area A1 - A10 in which word lengths of different lengths are contained.

Now I want to take the word with the greatest length in cell A20.

Does somebody has any idea...
SCL
slowly getting better (without VBA)


Posted:
Feb 11, 2014, 12:58 pm
First name:


       Version: Office XP (2002)

Hello,

without auxiliary column:
Do not enter {}, but exit the formula line with CTRL + SHIFT + ENTER
Code:
{= INDEX (A1: A10; COMPARE (MAX (LENGTH (A1: A10)); LENGTH (A1: A10); 0))}


For larger amounts of data, it is advisable not to use matrix formulas and to use an auxiliary column solution:
Code:
in B1 (then copy down): = LENGTH (A1)
then in A20: = INDEX (A1: A10; COMPARE (MAX (B1: B10); B1: B10; 0))

_________________
greeting
SCL
    UpAll times are
GMT + 1 hour
You can Post in this forum.
You can Reply to posts in this forum.
You can your posts in this forum Not to edit.
You can your posts in this forum Not Clear.
You can to polls in this forum Not participate.
You can Files in this forum Not Post
You can Download files in this forum

Related topics
Forum / Topics reply author Calls last contribution
Excel formulas: differentiation between text and numbers in a cell5hmmmmm ???116602 Feb 2005, 12:13
hmmmmm ???
Excel formulas: counting arguments in a cell2fridgenep1538Jan 31, 2005, 2:52 pm
fridgenep
Excel formulas: write words from one cell into 2 cells2Sven791322Jan 12, 2005, 1:20 am
Sven79
Excel formulas: Move cell2Muran62802 Jan 2005, 11:04 pm
Patrick G.
Excel formulas: filename in one cell6natorius194603 Dec 2004, 4:25 pm
natorius
Excel formulas: if the cell is full then15umbroboy7276Oct 31, 2004, 11:15 am
pehbeh
Excel formulas: split the text of a cell2Guest Chris278628 Oct 2004, 12:32
Guest Chris
Excel formulas: copy the first characters of a cell to another2fisler08153067Oct 11, 2004, 3:37 pm
fisler0815
Excel formulas: Find cells in a specific row12lhh2034Sep 15, 2004 at 10:21 am
lhh
Excel formulas: Function: Identical content of a cell in table 1 and 24luki420209 Sep 2004, 6:20 pm
guest
Excel formulas: cell formatting (formula)5guest134701 Sep 2004, 1:19 pm
ae
Excel formulas: again: last filled cell in column4guest378514 Aug 2004, 11:57
guest