Delete duplicate data.

  • Thread starter Thread starter Leo Leong
  • Start date Start date
L

Leo Leong

Hi,

I have thousands of rows, and each of them contains several columns of
data. If I want to delete the duplicated rows, how can I do that?

Example,

Cust ID Name Desc
001 John sg1.
002 Sam sg2.
001 John sg1.

I want to delete the duplicated customer ID of 001? Thanks.

Leo
 
Assuming that the entire row is duplicated as in you example you can use
Advanced Filtering.

Data > Filter > Advanced Filter > Unique Records Only. You can than copy
and paste.

If the entire row is not duplicated, it's a little more complicated. You
can extract the unique rows with a formula like this:

=IF(COUNTIF($A$2:$A2,$A2)=1,A2,"")

which assumes that column A is a suitable key. This will pull only the
first record for each key. Then you can Edit > Copy > Paste Special >
Values and then Data > Sort the list to remove blank rows.

Alternatively, you could use a macros to remove the dupes.

HTH

-Dave
 
Back
Top