|
|
#1
06-28-2011, 01:14 PM
|
|||
|
|||
Compare 4 columns & find dissimilar
I have 2 spreadsheets with 2 columns in each that I need to compare. Sheet A has a part and a price column, as does Sheet B. I need to compare the part column in A to B and then the price column in A to B and if the price of the part in A is different than the price of the part in B, I need to calculate the difference in a separate column. Can anyone help? 
|
| Tags |
| excel compare |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Compare and Update Macro | AaronMoss | Excel Programming | 2 | 05-06-2011 04:54 AM |
 How to compare 2 columns with other two columns in EXECL 2007?
|
Learner7 | Excel | 5 | 06-12-2010 09:54 AM |
| Compare document | enthu | Word | 1 | 05-19-2010 10:32 PM |
|
Compare data in different columns in an Excel sheet
|
kgfendi | Excel | 5 | 05-16-2009 05:42 PM |
|
compare files
|
rmartin8 | Word | 1 | 02-10-2009 10:27 AM |
Windows XP 
Office 2007
Threaded Mode