Duplicates in two columns

[rmottier]

I have two columns of data, I and M and need to find the cases where duplicates occure in I but the data in M does not match. If the data in M matches then it's ok. I have column I sorted A to Z.

 

[Joe4]

You can use functions like COUNTIF or VLOOKUP to look to see if a value is contained in a list (and hence, matches).

Take a look at these functions in Excel's built-in help files for details and exanmples, and post back here to this thread if you run into problems using them.