Be able to move not delete filtered records, to see the duplicats

[Guest]

I know how to filter out the duplicates, but I want to see exactly which ones
were duplicates. Any way to do this?

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...dg=microsoft.public.excel.worksheet.functions

 

[Guest]

I've done this using a Pivot table.

 

[JVLOLLAR]

If you use the count function, you can auto filter the results for an
Count results that aren't 1

 

[Guest]

one way to do it visually is to use conditional formating
if column A is the column of interest
formula is =countif($A$1:$A$1000,A1)>1
set formating as you want
Note you may have to go back into The Conditional Formating drop down and
check that it did not add Quote marks around the equation. this seems ot
happen occasionally.

 

[Debra Dalgleish]

Chip Pearson has information on finding and tagging duplicate entries in
a list.

http://www.cpearson.com/excel/duplicat.htm