For each set of PPIDs that has a “Delete” value and no “Reassign”, how would I populate the Intended Result column. In this example, I only need to populate “Delete” for PPIDS 123 and 789 because there is no “Reassign” value

CodePudding user response：

In cell C2 try:

=IF($B2="Delete",IF(SUMPRODUCT(($A$2:$A$8=$A2)*($B$2:$B$8="Reassign"))=0,"Delete",""),"")

CodePudding user response：

Assuming to start at A1 for PPID: B1 cell should contain: if(and(a1=a2,b2=""),"Delete", "") Copy that formula into all B cells. The formulas will adjust the references.