Display text with more no. of characters in a range

Hello everyone,

I need your help. I want to display a text which has more of no. of characters in a range.

Example:

Col A
India
India
United States
India

Answer: United States

I would need "United States" to be displayed as answer since this text has more no. of characters in the column A.

Thanks in advance.

With strings in A4:A99, try

Formula:

=INDEX(A4:A99,MATCH(MAX(INDEX(LEN(A4:A99),0)),INDEX(LEN(A4:A99),0),0))

The 2nd and 3rd INDEX calls should allow you to avoid array formula entry. However, you could shorten this to

Formula:

=INDEX(A4:A99,MATCH(MAX(LEN(A4:A99)),LEN(A4:A99),0))

as an array formula, so typing this formula then holding down [Ctrl] and [Shift] keys before pressing [Enter].

Thank you both for your quick response!