- last edited on
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.
07-08-2019 07:48 AM
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).