Hi All,

I'm in need of a method for removing duplicates. The built-in duplicate remover in Excel '07 will not work in my case because it only removes one of the duplicates. I need both duplicates removed, so that I'm only left with the unique entries. For example:

Original:
A | B
John | Smith
Suzie | Baker
Bob | Marley
Lauren | Kaine
Suzie | Baker
Bob | Marley

After Excel's built-in duplicate removal (won't work for me):
A | B
John | Smith
Suzie | Baker
Bob | Marley
Lauren | Kaine

What I need:
John | Smith
Lauren | Kaine

Can anyone advise a way to accomplish this?

Many thanks in advance!
J