Problem Filtering out Duplicates


I have a large data seet. I want to remove any rows for which the ID number (listed in the first column) has previously appeared. If this works correctly I expect about 40% of the entries to be removed.

However, when I use Data->Filter->Standard Filter-> Option-> Remove duplicates ALL my data points are being removed.

I’m not sure why this is happening. I would include the screenshot or attach the data but I do not correctly have enough karma points.


I think this will work.

Select the cells only in your ID column. Choose Data/Filter/Standard Filter
Filter selection criteria Column = . ( a single period)
Options checked: Regular expression, No Duplications
Click OK
This only hides the duplicate cells. Select the whole block and copy/save to another location to remove the hidden cells.

That did not work. Thank you for trying though