Compare values in different columns

J

JJM0926

I'm trying to compare the values in 4 different columns. Then I want
to take just the largest value between them and populate it into a new
column. Is there an easy way to do this? Any help or insights would
be greatly appreciated. Thanks.
 
T

Toppers

=MAX(A1:D1) will give maximum value in cells A1 to D1

or

=MAX(A1,C1,F1,K1) if not contiguous cells

HTH
 
Top