If u don't want to use formulars u can do this using the Advance Filter
option. Data Filter Advance filter, then select the appropriate
options and ensure that the check box at the bottom "Unique records
only" is flagged.

Although this will not delete them u can "Copy to another location" and
then delete the original one later. I usually use this option to refer
back to the original list later if the need arises.

Cheers.


--
terabar
------------------------------------------------------------------------
terabar's Profile: http://www.excelforum.com/member.php...o&userid=24272
View this thread: http://www.excelforum.com/showthread...hreadid=379145