| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
filter duplicates
Hoping someone can help, I have a filter list that contains duplicates. I
have set up the advanced filter and have applied the filter countif($A$2:$a$1000,A2)1 but it doesn't seem to work. I think the logic is correct as I have tried it on a conditional format and that works fine. Can I do what I'm trying to do? I DON'T want to delete the duplicates, I want to keep them! In preference I want to lose the unique records. Any ideas? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Filter duplicates by multiple criteria | New Users to Excel | |||
| Find, Filter and Paste Duplicates | Excel Discussion (Misc queries) | |||
| Filter out duplicates | Excel Discussion (Misc queries) | |||
| Show duplicates in cell for filter | Excel Discussion (Misc queries) | |||
| Filter for duplicates | Excel Discussion (Misc queries) | |||
Threaded Mode
