Deleting Duplicate Rows

  • Thread starter Thread starter Connie
  • Start date Start date
C

Connie

I've not had success using the macros listed to delete
rows where the first cell is the same. For example,

* Sheet1 has name in column 1 (shorter file)
* Sheet2 has name in column 1 and address in column 2
(longer file)

I want Sheet1 to drive the selection of rows in Sheet2,
resulting in a name and address subset file of Sheet2.

Thank you,
Connie
 
in sheet2 put a formula in column 3

=if(countif(Sheet1!A:A,A1)>0,"Keep","Delete")

You can copy this down the column, then use the Autofilter to extract the
rows you want.

Use the same approach in a macro.
 
Tried your suggestion but it only worked by placing a Keep
in the first row of sheet 2....all other rows said
delete....thanks!
 
It works fine for me and should work for you. I suspect your problem lies
with your data not matching. Possibly you have blanks spaces on the end of
your data in one sheet or the other.
 
Back
Top