Max Function

I

Iriemon

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

Thanks

Irie
 
G

Gary''s Student

If the data contains no duplicated values:

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

Rick Rothstein

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?
 
Top