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
|