I'm not really sure what you are trying to do!
Do you wish to delete all the rows that have 'Duplicate' in Column 'D'?

If yes, then select D2 Click Data on the top toolbar Filter
Autofilter.
This will put a small down arrow above all columns that contain data.
Click the down arrow in column 'D' and click on 'Duplicates'
This will show all the duplicate rows.
Select all the rows you wish to delete, by highlighting the row header
numbers,
right-click, select 'Delete row'.

Practise on a copy of your worksheet first.

To show all rows again: Data Filter 'Show all'.

George Gee



"kbkst via OfficeKB.com" <u18755@uwe wrote in message
news:5c458f6da91b2@uwe...
It worked!! Thank you so much. Do you know how to delete the duplicate
numbers? When I do a delete row for a number it deletes the first number
and
then deletes all the text that says "duplicate", but does not delete the
numbers.

kbkst

George Gee wrote:
You don't copy the formula into the 'C' column.
You copy the formula into all the rows in the 'D' column,
alongside all the cells that contain your pasted numbers.
Copy and paste this formula into D2,
=IF(MAX(COUNTIF(C:C,C:C))1,"Duplicate","Non Duplicate")
Drag it down the column as far as you have numbers in Column C.
Or with D2 selected, double-click the small black square at the
bottom right of the cell.

George Gee

George Gee:
I need help. Cannot get this to work. My numbers are pasted in Column
C
[quoted text clipped - 19 lines]
Hope someone can help.
kbkst

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...l-new/200602/1