"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