Assuming the data is in column A
In B1 add, =COUNTIF($A$1:A1,A1)>1, and copy down as many rows as in A
Then insert a row at row 1
Then do an autofilter on column B. Select column B, Data>Filter>Autofilter.
Click the dropdown arrow in B1, and select TRUE, only the duplicates will be
visible.
Select the duplicates, F5>Special... and click Visible cells only
Delete duplicates, Ctrl - together, click Yes when it asks Entire row?
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
