# 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
 Up All 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 PostYou can Download files in this forum

 Forum / Topics reply author Calls last contribution Related topics Excel formulas: differentiation between text and numbers in a cell 5 hmmmmm ??? 1166 02 Feb 2005, 12:13hmmmmm ??? Excel formulas: counting arguments in a cell 2 fridgenep 1538 Jan 31, 2005, 2:52 pmfridgenep Excel formulas: write words from one cell into 2 cells 2 Sven79 1322 Jan 12, 2005, 1:20 amSven79 Excel formulas: Move cell 2 Muran 628 02 Jan 2005, 11:04 pmPatrick G. Excel formulas: filename in one cell 6 natorius 1946 03 Dec 2004, 4:25 pmnatorius Excel formulas: if the cell is full then 15 umbroboy 7276 Oct 31, 2004, 11:15 ampehbeh Excel formulas: split the text of a cell 2 Guest Chris 2786 28 Oct 2004, 12:32Guest Chris Excel formulas: copy the first characters of a cell to another 2 fisler0815 3067 Oct 11, 2004, 3:37 pmfisler0815 Excel formulas: Find cells in a specific row 12 lhh 2034 Sep 15, 2004 at 10:21 amlhh Excel formulas: Function: Identical content of a cell in table 1 and 2 4 luki 4202 09 Sep 2004, 6:20 pmguest Excel formulas: cell formatting (formula) 5 guest 1347 01 Sep 2004, 1:19 pmae Excel formulas: again: last filled cell in column 4 guest 3785 14 Aug 2004, 11:57guest