Erase duplicate rows

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I need to create a macro that checks duplicate rows and erases them.
(Erase in the example rows containing 21 and 32, because they are duplicated.

Ie:
A B
21 XZ
32 PR
21 XZ
75 KL
32 PR
 
I think, the topic 'Please help with a "find duplicates" macro - 4/10/07'
on "microsoft.public.excel.worksheet.functions" can help you.
There is a macro that compare two columns from two sheets and remove the
duplicates from one of them
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

duplicate rows 2
Change Text Colour Of Lowest Value 4
macro help 1
Elimination of Duplicates in an Array and its reduction. 10
Variable Incrementing 3
Calculate sum of values based on a ref value, how? 4
How to insert row on Col A field change 2
"differential" comparison 1

Back
Top