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

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/comm...et.f unctions

I've done this using a Pivot table.

"hmadari" wrote:

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/comm...et.f unctions

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


--
JVLOLLAR
------------------------------------------------------------------------
JVLOLLAR's Profile: http://www.excelforum.com/member.php...o&userid=23721
View this thread: http://www.excelforum.com/showthread...hreadid=373888

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.


"hmadari" wrote:

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/comm...et.f unctions

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

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


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


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html