Ask Your Question

Problem Filtering out Duplicates

asked 2015-11-26 04:14:31 +0200

Shani92 gravatar image


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.


edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2015-11-26 16:13:17 +0200

w_whalley gravatar image

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.

edit flag offensive delete link more


That did not work. Thank you for trying though

Shani92 gravatar imageShani92 ( 2015-11-30 01:00:50 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2015-11-26 04:13:57 +0200

Seen: 237 times

Last updated: Nov 26 '15