Thread: [Solved] Compare 4 columns & find dissimilar
View Single Post
 
Old 06-28-2011, 01:14 PM
kmorrin kmorrin is offline Windows XP Office 2007
Novice
  
Join Date: Jun 2011
Posts: 2
kmorrin is on a distinguished road
Question 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?
Reply With Quote