how do I find a max TEXT value?

[Guest]

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

 

[JE McGimpsey]

One way (array-entered: CTRL-SHIFT-ENTER or CMD-RETURN):

=CHAR(MAX(CODE(A1:A10)))

Adjust the range as required.

 

[RagDyeR]

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!
=====================================================


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