| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Bug in Advanced filter
I think I have discovered a bug in the way Advanced Filter filters out
duplicates. When I perform this function and have the results pasted to another location (or new worksheet) if the first 2 rows are duplicate they are treated as not being duplicate. That is, it lists the first 2 rows in the target location even though they are duplicate. It seems to work fine for other rows. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Bug in Advanced filter
It is not a bug.
Excel treats the top value as a Title/list header unless you tell it not to. So.......you get Cat as Title and Cat as first unique in the list below. Gord Dibben MS Excel MVP On Sat, 13 Mar 2010 14:25:01 -0800, GregNga wrote: I think I have discovered a bug in the way Advanced Filter filters out duplicates. When I perform this function and have the results pasted to another location (or new worksheet) if the first 2 rows are duplicate they are treated as not being duplicate. That is, it lists the first 2 rows in the target location even though they are duplicate. It seems to work fine for other rows. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Advanced Filter - filter rows < | Excel Discussion (Misc queries) | |||
| Why won't advanced filter return filter results? | Excel Worksheet Functions | |||
| How do I use advanced filter to filter for blank cells? | Excel Discussion (Misc queries) | |||
| "Criteria Range" in the "Data/Filter/Advanced Filter" to select Du | Excel Worksheet Functions | |||
| advanced filter won't allow me to filter on bracketed text (-456.2 | Excel Discussion (Misc queries) | |||
Hybrid Mode
