Sort the column you want to find the duplicate data, (assume Column A)
Insert a Column or go to a empty column, (column B for this example).
Make sure you data you want to check for duplicates starts at Cell A2.
In Cell B2 enter the following formula: =IF(A2=A1,"Dup","Not Dup"), and
copy it down. Now you should be able to filter on the DUP and just
delete those values.


--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: http://www.excelforum.com/member.php...o&userid=29640
View this thread: http://www.excelforum.com/showthread...hreadid=505982