Ask Your Question

How to check for duplicates? [closed]

asked 2013-12-23 06:47:40 +0200

Amit gravatar image

How to check for duplicates in a column in .xlsx file?

edit retag flag offensive reopen merge delete

Closed for the following reason duplicate question by oweng
close date 2014-01-26 01:24:57.913994

2 Answers

Sort by » oldest newest most voted

answered 2013-12-23 11:59:11 +0200

oweng gravatar image

Same/similar question asked in other threads:

Various different answers because what constitutes a duplicate can vary according to example.

edit flag offensive delete link more


Can you close the question as "duplicate" or "unclear"?

bencomp gravatar imagebencomp ( 2014-01-25 13:03:25 +0200 )edit

answered 2013-12-23 10:50:28 +0200

L-user gravatar image

updated 2013-12-23 11:06:10 +0200

If you only would like to check for duplicates in a column, I suggest to do the following:
1. Mark a whole column (like clicking on column A if duplicates are in this column).
2. Right click and Copy.
3. File | New Spreadsheet.
4. Click in cell A1 in new spreadsheet and right click then Paste.
5. Click on header of column A1 to select whole column.
6. Data | Sort and apply default.
7. In Cell B2 type in formula: =IF(A1=A2;"DUPLICATE";"")
image description
8. Copy down the formula in B column. If there is a duplicate there will be written DUPLICATE.

If you would like to remove a duplicates then see the following tutorial:

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2013-12-23 06:47:40 +0200

Seen: 94,022 times

Last updated: Dec 23 '13