Prev: Questions
Next: How to unhide column?
From: Iriemon on 18 May 2010 13:33
Is there any function available that works similar to the MAX function for
alpha characters?

Thanks

Irie
From: T. Valko on 18 May 2010 13:45
Probably

--
Biff
Microsoft Excel MVP


"Iriemon" <Iriemon(a)discussions.microsoft.com> wrote in message
news:B487550B-21E4-485F-8BEB-869D4F7CDF16(a)microsoft.com...
> Is there any function available that works similar to the MAX function for
> alpha characters?
>
> Thanks
>
> Irie


From: Gary''s Student on 18 May 2010 14:21
If the data contains no duplicated values:

=INDEX(A1:A100,MATCH(COUNTA(A1:A100)-1,INDEX(COUNTIF(A1:A100,"<"&A1:A100),0),0)­)


--
Gary''s Student - gsnu201003


"Iriemon" wrote:

> Is there any function available that works similar to the MAX function for
> alpha characters?
>
> Thanks
>
> Irie
From: Rick Rothstein on 18 May 2010 16:20
Can you give us just a little more information please? Are we talking about
single characters per cell, multiple characters per cell (what would maximum
mean to you for this situation) or max character in a text string within a
single cell?

--
Rick (MVP - Excel)



"Iriemon" <Iriemon(a)discussions.microsoft.com> wrote in message
news:B487550B-21E4-485F-8BEB-869D4F7CDF16(a)microsoft.com...
> Is there any function available that works similar to the MAX function for
> alpha characters?
>
> Thanks
>
> Irie

 | 
Pages: 1
Prev: Questions
Next: How to unhide column?