ExcelBanter - MAX formula for alphabetical letters

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - MAX formula for alphabetical letters (https://www.excelbanter.com/excel-discussion-misc-queries/28578-re-max-formula-alphabetical-letters.html)

bigwheel

MAX formula for alphabetical letters

"Will Grattan" wrote:

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

One way, in a helper row, put the formula =CODE(A1) and copy for as many
cells as required.

Then you can determine the MAX value and turn it back into a letter with CHAR
like this - =CHAR(MAX(A2:E2))

HTH

Jason Morin

=CHAR(MAX(CODE(IF(1:1<"",1:1,0))))

Array-entered, meaning press ctrl + shift + enter.

HTH
Jason
Atlanta, GA

"Will Grattan" wrote:

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

All times are GMT +1. The time now is 04:32 PM.