Finding duplicate value based on multiple criteria from another column

Hello fellow Excel users,


I was hoping I would be able to find some support here with a formula I am hoping to find that solves my issue.


I want to find duplicates in one column (A) based on the criteria (CA or US, NOT UK) in another column (B) and I want the result to show in column C. See example photo below (having issues uploading excel workbook):

Sample data for Excel issue.JPG

The issue is, I don't want to see a duplicate if that duplicate is only present within US (ex. row 3 & 4) and rather only if the duplicate is found both in US and CA. I also don't want to a duplicate to pop up if the value in column B is UK (ex. row 7 serial number is a duplicate, but the country sale is UK and NOT CA or US).

Any help would be appreciated.

I have also posted this question on another site, as finding the result is time sensitive. I will however remove this post ASAP if my question is answered on the other forum (tech community Microsoft forum).