compare 2 columns in excel

Microsoft Office excel 2007 - upgrade
June 13, 2010 at 23:50:02
Specs: Windows 7
I need to compare corresponding cells of two
columns in excel and display the smaller of the
two values in the corresponding cell of a third
column.

Any help would be appreciated. Thanks.


See More: compare 2 columns in excel

Report •

#1
June 14, 2010 at 03:55:02
Hi,

with your two values in A1 and B1, put this formula in C1:

=IF(A1<B1,A1,B1)

Drag the formula down column C as far as there are values to be compared in columns A and B.

You didn't say if you wanted anything different if the values in A and B were the same. If you do, please respond with further information.

Regards
PS as the IF() statement is such a basic building block for formulas in Excel, I suggest you read the help file, so that you understand how it works, and how IF() statements can be nested.


Report •

#2
October 14, 2010 at 10:29:36
Hello, I have been scanning the web trying to find a formula that can calculate the difference between 2 columns placing that number in a row below with conditional formatting showing red increase, yellow same, and blue decrease. Below is the actual numbers: dates followed by data below, and then the sum, with the difference between the rows (manually completed) If you would be so kind to assist, I'd be much appreciative - thank you for your time.

10/10/10 10/11/10 10/12/10 10/13/10 10/14/10 10/15/10

366 375 375 377 378
257 257 257 253 253
55 55 55 56 56
32 32 32 30 30
5 5 5 5 5
28 28 28 28 28
4 4 4 4 4
336 338 337 338 337
198 198 198 194 191
400 400 400 391 391
14 13 13 13 13
1695 1705 1704 1689 1686

10 -1 -15 -3


Report •
Related Solutions


Ask Question