View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] rjmagana@gmail.com is offline
external usenet poster
 
Posts: 4
Default Help with data Comparison

I have the following:
Column A Column B
-------------- ------------
Item Number Price

Column A has duplicate item numbers. How can I find the duplicate Item
numbers and then compare if the duplicate ones have the same price or
not. Can this be done with just one formula or two. Or do you have to
do VB code for this? Someone suggested using a pivot table, but I don't
think that would work, would it?