Forum Discussion

Copper Contributor

Jul 02, 2019

Solved

Removing duplicates

How do I remove duplicate values associated with a name only? I have a number of the duplicate values that are repeated across a table range and correspond to different names (in the column to th...

Oct 15, 2019

Thank you for the clarification. With this I'd use the formula as

=IF( COUNTIF($D$2:$D2,$D3),0, SUMPRODUCT(('N:\Audit Database\2019 Audits\Los Angeles\November 2019\Environmental\Losses\[Environmental Loss Run 10.14.19.xlsx]Sheet1'!$A:$B=D3)*1))

and apply to column custom number format as