Find the maximum value in a row or column with text and numbers

[bengles]

would someone be able to help me out in finding the maximum value in a row or
column containing letters and numbers. letters in this case would be a lower
value compare to the numbers.

for example in a row:

A B C D <- returns the value D as max
A B 0 1 <- returns the value 1 as max

thanks

 

[Jarek Kujawa]

for A B C D use array-entered (i.e. insert the formula with CTRL+SHIFT
+ENTER):

=CHAR(MAX(CODE(A11)))

for A B 0 1 use:

=MAX(A11)

 

[Ms-Exl-Learner]

Try this…

Paste this formula in F1 cell.

=IF(MAX(A1:E1)=0,CHAR(MAX(CODE(A1),CODE(B1),CODE(C1),CODE(D1),CODE(E1))),MAX(A1:E1))

Change the cell reference to your desired cell, if required.

If this post helps, Click Yes!