Compare columns + calculate difference

Inatic · #1 01-24-2013, 09:47 AM

Hello I have a small question actually i wont to compare 2 columns from my list : A and C, and those who match paste into E. Later i was trying to compare the 2 Prices from the same product and show the difference in % Sorry for my bad English I hope the attachments will show it clearer.

OTPM · #2 01-27-2013, 08:00 AM

Hi
Have a look at the spreadsheet attached.
Hope this helps.
Good luck.
Tony

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Insert picture options, what's the difference?	Jennifer Murphy	Drawing and Graphics	3	10-09-2012 05:12 AM
Using COMPARE to compare more than two variables	Wyskers	Word	1	12-03-2011 01:37 AM
Compare 4 columns & find dissimilar	kmorrin	Excel	4	06-29-2011 04:38 PM
How to compare 2 columns with other two columns in EXECL 2007?	Learner7	Excel	5	06-12-2010 09:54 AM
Compare data in different columns in an Excel sheet	kgfendi	Excel	5	05-16-2009 05:42 PM