Ask Your Question

how to find and remove duplicates automatically [closed]

asked 2013-05-31 23:09:27 +0100

zemko gravatar image

I have a dataset of few lists and columns, each column has from 2 000 to 160 000 rows, I need to find duplicates in each columne and then remove/erase them, I know that in data - filter is option to hide (unfilter) them, but I need to erase/remove them like it is working on Excell

I also know about IF function =IF(A2=A3;1;0), but I dont need to find them, i need to erase them automaticaly

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-11-02 00:32:34.873966

2 Answers

Sort by » oldest newest most voted

answered 2013-05-31 23:53:32 +0100

mahfiaz gravatar image
edit flag offensive delete link more

answered 2013-06-01 00:44:50 +0100

zemko gravatar image

mahfiaz: yeah, I know about this, as mentioned in my question, I am looking for something like Excell has Data - Data Tools - Remove duplicates... it is automatic tool that remove all duplicates in the column, or in the range of cells you choose, and shrink rows automatically

edit flag offensive delete link more


Go To -> Data-> Filter -> Advanced Filter -> Select Column Range -> Click on options -> Check " No Duplicates" .... :)

G V gravatar imageG V ( 2015-12-01 17:52:50 +0100 )edit

that is not how it works on the latest version I have.

Cosmo1953 gravatar imageCosmo1953 ( 2017-04-04 02:49:11 +0100 )edit

Also did not work for me, however the standard filter worked -- it hid the duplicate rows so I could copy the unique values (97 from 87k rows) into a further column, as I sort of wanted. When I wanted to overwrite the same column, it did overwrite (using M1 top of column), but didn't delete the dups.

Tom G gravatar imageTom G ( 2018-10-03 15:19:03 +0100 )edit

Question Tools

1 follower


Asked: 2013-05-31 23:09:27 +0100

Seen: 139,853 times

Last updated: Jun 01 '13