Identify Duplicates with 2 criteria
Hello, I am trying to flag duplicates that meet 2 criteria. I have a sheet that has Request type actions (Add, Revise, Delete, etc.) and also a Part ID column. I am trying to identify duplicate Part ID that also have the same Request type. See screenshot.
Ex: Row 1 and 4 should flag as duplicates as they are the same part ID and both of those unique part number rows identified as duplicates are also "ADD" requests. Row 2 is not flagged because even though the same Part ID, it is a "Delete" request.
All I can find are solutions with identifying 1 criteria....like this:
=IF(COUNTIF([Part ID]:[Part ID], [Part ID]1) > 1, 1,0)
Any help would be appreciated.
Help Article Resources
Check out the Formula Handbook template!