MAX formula for alphabetical letters
 

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

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),“ABCDEFGHIJKLMNOPQRSTUVWXY Z”,1)

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

Matt


--
Flintstone
------------------------------------------------------------------------
Flintstone's Profile: http://www.excelforum.com/member.php...o&userid=15310
View this thread: http://www.excelforum.com/showthread...hreadid=375428