Compare values in different columns
 

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.

Compare values in different columns
 

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

or

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

HTH

"JJM0926" wrote:

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.

Compare values in different columns
 

On Jun 27, 3:24 pm, Toppers wrote:
=MAX(A1:D1) will give maximum value in cells A1 to D1

or

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

HTH



"JJM0926" wrote:
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.- Hide quoted text -

- Show quoted text -

Thanks. That worked perfectly!