On Tue, 8 Dec 2009 03:49:01 -0800, Otávio Alves Ribeiro
wrote:

Hi there.
Well, you did not tell us with which version of Excel you are working but,
if you are using Excel 2007, you can select your data range and choose Remove
Duplicates on Data tab.
Regards,
Otávio

How did you get that to remove all the records that had been duplicated, per
the OP's request?

When I tried that, it left one of the duplicates behind.
--ron