• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to compare multiple values?

nanao56

New Member
I need some help. I have to compare some data that has been flattened out. The differences in the data is that some of the data is from 1 of 2 source systems (CRM1 or OM1). There is a set of part numbers that is common between both source systems. I have to flag part numbers where the price is not the same.


Example of how the data is stored


CustomerNumber CustomerName SrcSystem nrmlzdpn Item Price

85249486 Company X CRM1 CD399A DS100 INK CYAN 1 GALON 303.2

85249486 Company X CRM1 CD400A DS100 1-GAL SPCL TXTL M INK 303.2

85249486 Company X CRM1 CD400A DS100 INK MAGENTA 1 GALON 303.2

85249486 Company X Inc. OM1 CD399A DS100 1-GAL SPCL TXTL C INK 303.2

85249486 Company X Inc. OM1 CD400A DS100 1-GAL SPCL TXTL M INK 308.2


I want to compare for where the customer number is the same, compare against CRM1 against OM1 (the SrcSystem field) where the nrmlzdpn field is the same value, flag if the price isn't the same.


I'm not sure at all how to do this.


Please help


THanks
 
Does conditional formatting with this formula do what you want?


=SUMPRODUCT(--($A$2:$A$6=A2),--($E$2:$E$6=E2),--($F$2:$F$6<>F2))=1
 
Back
Top