Identify Duplicates with 2 criteria

KevinL ✭✭✭✭
edited 12/09/19 in Formulas and Functions

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 this:  

=IF(COUNTIF([Part ID]:[Part ID], [Part ID]1) > 1, 1,0)

Any help would be appreciated.




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!