MAX formula for alphabetical letters

[Will Grattan]

Seems like it must be simple! I have a row of alphabetical letters from A-Z
and I would like to be able to formulate what the highest alphabetical letter
in that row (Z being the highest). The result therefore is the letter that is
the MAX. Help much appreciated

[Flintstone]

Hi Will:

=CODE(LEFT(UPPER(B1),1))-64

Lets say cell B1 contains the word, “apple”, this formula will convert it to upper case and return the ASCII code for the first left most character which is A, and subtract 64, making letter A = 1.

Or

=FIND(LEFT(UPPER(B1),1),“ABCDEFGHIJKLMNOPQRSTUVWXYZ”,1)

Same thing as above except instead of returning the letters code it will find its position in the formulas array, “ABCDEFGHIJKLMNOPQRSTUVWXYZ”.

Matt