Deleting duplicate rows

[Kevin]

How do I delete duplicate rows?? Please go step by step!! Thanks....

Brent

[Bob Phillips]

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)

"Kevin" <Kevin@discussions.microsoft.com> wrote in message
news:B231A6F3-A72B-414B-9566-54A8D2E27386@microsoft.com...
> How do I delete duplicate rows?? Please go step by step!! Thanks....
>
> Brent
>
>