Using LEN

[godrob]

Hello,

I'm using len to return the largest string in a column. What I would like to do is rather than display the amount of characters, actually display the cell data.

The formula I'm using is =max(len(F19:F500))

How can I add to this to display the cell value with the largest string.

Thanks

Rob.

 

[IML]

You could array (control shift enter) enter
=INDEX(F19:F30,MATCH(MAX(LEN(F19:F30)),LEN(F19:F30),0))

given the size of your actual range, you may be better served with a two cell contraction. Can you put the len formula in an unused column somewhere in rows 19:500?

 

[godrob]

Thanks,

That worked great.

Rob.