Below is a proposed solution for the challenge – Challenge 18 – Find the Longest Word in a List
Use following formula –
=INDEX(A1:A10,AGGREGATE(15,6,ROW(A1:A10)/
((MAX(INDEX(LEN(A1:A10),,))=LEN(A1:A10))),1))
The solution file can be downloaded from following – Solution – Challenge 18 – Longest Word
I have this alternate which will work even in earlier version of excel.
=INDEX(A1:A10,MATCH(MAX(INDEX(LEN(A1:A10),,)),INDEX(LEN(A1:A10),,),0))