| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Filter/Copy Unique records
I have this simple code.
Range("H:H").AdvancedFilter Action:=xlFilterCopy, CopyToRange:=Range("O1"), Unique:=True Im trying to get a list of the Unique reords in column H. For some reason if row H1 and H2 are the same I end up with 2 records the same. Example: H1 = 249653634 H2 = 249653634 H3 = 445434212 H4 = 551569206 H5 = 551569206 H6 = 551569206 H7 = 249721825 H8 = 445531266 H9 = 249877803 H10 = 351145588 H11 = 351145588 I end up with a list that is not Unique as listed below 249653634 249653634 445434212 551569206 249721825 445531266 249877803 351145588 If H1 and H2 are different then everythig is good. Am I missing something? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatic filter for unique records | Excel Worksheet Functions | |||
| unique records by advanced filter | Excel Discussion (Misc queries) | |||
| Filter out unique records from pivot | Excel Worksheet Functions | |||
| Filter Unique Records | Excel Discussion (Misc queries) | |||
| unique filter results in some non-unique records. | Excel Discussion (Misc queries) | |||
Threaded Mode
