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

  • Thread starter Thread starter bengles
  • Start date Start date
B

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
 
for A B C D use array-entered (i.e. insert the formula with CTRL+SHIFT
+ENTER):

=CHAR(MAX(CODE(A1:D1)))

for A B 0 1 use:

=MAX(A1:D1)
 
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!
 
Back
Top