Forum Discussion
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 the right of the values.)
I only want to delete duplicate values associated with each corresponding name only, and not all duplicate values in the table range. Thanks.
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
General;General;"-"??;@to hide zeros.
11 Replies
Hey MMcDonal
Try This:
* Select the range you want to remove the duplicates from, Go into the Data Tab, under the data tools group click Remove Duplicates:
* Check the two column you want to remove the Duplicates from and click OK
Thanks EWC. I believe your method would remove all duplicate values irrespective of the duplicate values based on different sources.
See screenshot below of a larger spreadsheet where there are duplicate values. My goal is to remove only duplicate values by source only. So in this case, removal of all duplicate values by source (name), including the $3,000 duplicate value for GenD, but not for Henry S. and HewP since they are separate sources/names.
The $3,000 values for GenD and HenryS should remain intact/not removed, since they are separate sources of the duplicate values within the range (spreadsheet).
Thanks!
MMcDonal
To remove by source select all columns in your range and check only one with source
Result is
