Macro to delete duplicate records

[Guest]

Hi,

I have a question - how would you write a macro to delete duplicate rows, depending on one specific column to determine duplicates?

Thank you for your help!

 

[Tom Ogilvy]

http://www.cpearson.com/excel/deleting.htm
at Chip Pearson's site. Page has a section on deleting duplicate rows.

--
Regards,
Tom Ogilvy

Hi,

I have a question - how would you write a macro to delete duplicate rows,

depending on one specific column to determine duplicates?

 

[andycharger]

Hi Tom,

What about if you have 10 duplicates in Column 1 and then you need to
find the ones that are dplicated in column 2 as not all match, what do
you do?

i.e

1 A
1 B
1 A
2 A
2 B
2 A


would leave you with


1 B
2 B