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!

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!

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/