title: Formula to find max & min of string if sort alphabetical
body: <p>if I have a list of string like '0401 A', '0319 B' '0801 C' and they appears in different columns and rows in an excel sheet, what is the formula to get the max &amp; min of these strings. In this case, max and min would be '0801 C' and '0319 B' if its sorted alphabetically. INDEX-MATCH doesn't seems to work since the strings are in multiple rows and columns</p>