How to find the largest letter in a range in Excel?
Let’s say there are different letters in a range, how can you quickly know what the max or largest letter is in this range? To check the letters one by one is not a smart way, here I have a formula that can quickly find out the largest letter in a range in Excel.
Just use below formula to find the largest letter in a range.
Select a cell which you will place the result at, and then type this formula =LOOKUP(2,1/(COUNTIF(A1:A14,">"&A1:A14&"*")=0),A1:A14), press Enter key to get the result.
In the formula, A1:A14 is the range that you find the max letter from.
Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time. Click Here to Get The Feature You Need The Most...