Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
automatically delete records w/duplicate address in excel | Excel Discussion (Misc queries) | |||
returning value from filtered records | Excel Discussion (Misc queries) | |||
how do I see more than 1000 records filtered | Excel Discussion (Misc queries) | |||
How do I delete filtered lines in Excel 2000? | Excel Worksheet Functions | |||
How to delete duplicate records when I merge two lists (deleting . | Excel Worksheet Functions |