Compare values in different columns

  • Thread starter Thread starter JJM0926
  • Start date Start date
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.
 
=MAX(A1:D1) will give maximum value in cells A1 to D1

or

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

HTH
 
Back
Top