Finding the cell with the most characters

  • Thread starter Thread starter arcandio
  • Start date Start date
A

arcandio

Alright, fir one of my current projects, I need to output the contents
of the cell with the most text in it from a column. How would I do
this? I've tried arrays based on LEN, but I get the number of
characters instead of the cell contents.
 
Alright, fir one of my current projects, I need to output the contents
of the cell with the most text in it from a column. How would I do
this? I've tried arrays based on LEN, but I get the number of
characters instead of the cell contents.
Click to expand...

This *array* formula (enter with <ctrl><shift><enter>) should return the
contents of the cell with the most characters. Rng refers to the appropriate
column (e.g. rng refers to: A1:A100).

=INDEX(rng,MATCH(MAX(LEN(rng)),LEN(rng),0))



--ron
 
This *array* formula (enter with <ctrl><shift><enter>) should return the
contents of the cell with the most characters. Rng refers to the appropriate
column (e.g. rng refers to: A1:A100).

=INDEX(rng,MATCH(MAX(LEN(rng)),LEN(rng),0))

--ron
Click to expand...

Thanks very much Ron! I actually ended up solving the thing by adding
each cell to the one above it till it got to the top. This will help a
lot in other parts though!
 
Back
Top