compare 2 columns in excel

Humar 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.

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