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