how do I find a max TEXT value?

[Phoebe]

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.

In article <[email protected]>,
Phoebe <[email protected]> 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

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


"Phoebe" <[email protected]> wrote in message
news:[email protected]...
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