Macro to delete duplicate records
 

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!

Macro to delete duplicate records
 

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

--
Regards,
Tom Ogilvy

"Horselover" wrote in message
...
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!

Macro to delete duplicate records
 

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


---
Message posted from http://www.ExcelForum.com/