how do I find a max TEXT value?
 

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

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

how do I find a max TEXT value?
 

One way would be this *array* formula:

=CHAR(MAX(CODE(A1:A5)))
--
Array formulas are entered using CSE, <Ctrl <Shift <Enter, instead of the
regular <Enter, which will *automatically* enclose the formula in curly
brackets, which *cannot* be done manually.

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===


"Phoebe" wrote in message
...
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