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 <C28D4B96-68C7-44FA-AE33-9A2E17E23E9D@microsoft.com>,
Phoebe <Phoebe@discussions.microsoft.com> 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" <Phoebe@discussions.microsoft.com> wrote in message
news:C28D4B96-68C7-44FA-AE33-9A2E17E23E9D@microsoft.com...
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