how do I find a max TEXT value?
One way (array-entered: CTRL-SHIFT-ENTER or CMD-RETURN):
=CHAR(MAX(CODE(A1:A10)))
Adjust the range as required.
In article ,
Phoebe wrote:
I am trying to use the max function but on a series of text values ie. a, f,
h, k - to return K as max value
|