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: