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
If you are unfamiliar with array formulas, see my video and explanation of arrays here.
Formula for maximum value:
Formula for maximum value length:
Formula for maximum value row (index number row in range of interest):
Formula for maximum value cell address:
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.