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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel - Wich Function should I use? 1
Resource Leveling Multiple Resources on one task 0
Compressing multiple functions across an array into one cell 6
Sorting by Frequency? 4
Want To Shrink Formula 1
Help with SUMIF formula 3
Max function for row with named cells 3
Drag and Drop does not work Outlook for Mac 0

Top