| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I want to compare the values in two columns | Excel Discussion (Misc queries) | |||
| compare values in two different columns in a table | Excel Discussion (Misc queries) | |||
| Compare values on sheet 1 to values on sheet2 | Excel Worksheet Functions | |||
| Compare values in columns | New Users to Excel | |||
| Excel Compare values in columns & display missing values in a new | Excel Discussion (Misc queries) | |||
Hybrid Mode
