I Iriemon May 18, 2010 #1 Is there any function available that works similar to the MAX function for alpha characters? Thanks Irie
Is there any function available that works similar to the MAX function for alpha characters? Thanks Irie
G Gary''s Student May 18, 2010 #3 If the data contains no duplicated values: =INDEX(A1:A100,MATCH(COUNTA(A1:A100)-1,INDEX(COUNTIF(A1:A100,"<"&A1:A100),0),0)Â)
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 May 18, 2010 #4 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?
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?
