**Tom’s Tutorials For Excel: Finding the Attributes of the Maximum Length Value in a List**

Here are formulas that return various attributes of the lengthiest value in a list. In the pictures are formulas for the lengthiest value itself; its length; its row in the list; and its cell address.

These are all array formulas. Recall, an array formula is applied to the cell by pressing

`Ctrl+Shift+Enter`

, not just `Enter`

.

If you are unfamiliar with array formulas, see __my video and explanation of arrays here__.

Formula for maximum value:

`=INDEX(A4:A10,MATCH(MAX(LEN(A4:A10)),LEN(A4:A10),0))`

Formula for maximum value length:

`=MAX(LEN(A4:A10))`

Formula for maximum value row (index number row in range of interest):

`=MATCH(MAX(LEN(A4:A10)),LEN(A4:A10),0)`

Formula for maximum value cell address:

`=ADDRESS(MAX(ROW(A4:A10)*(LEN(A4:A10)=MAX(LEN(A4:A10)))),1)`

Excellent!

I clicked on the link and found that the video is not available. Please restore it.

Thanks for letting me know. I’ll look at it tonight to see what’s going on.

Just edited the video’s URL. Please try the link again and see if now it works.