Max Function
 

Is there any function available that works similar to the MAX function for
alpha characters?

Thanks

Irie

Max Function
 

Probably

--
Biff
Microsoft Excel MVP


"Iriemon" wrote in message
...
Is there any function available that works similar to the MAX function for
alpha characters?

Thanks

Irie

Max Function
 

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

Max Function
 

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" wrote in message
...
Is there any function available that works similar to the MAX function for
alpha characters?

Thanks

Irie