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

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

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

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)




On 17 Lis, 09:26, bengles wrote:
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

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

Try this€¦

Paste this formula in F1 cell.

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

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

If this post helps, Click Yes!

--------------------
(Ms-Exl-Learner)
--------------------



"bengles" wrote:

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