krakatoa
asked on
Unique values
Applying AdvancedFilter Unique:=True to a simple column (A) values of, say, 1,1,1,1,1,2,3,4,5,6,7,7
will result in :
1,1,2,3,4,5,6,7
and NOT the required 1,2,3,4,5,6,7
Why? Thanks, k.
will result in :
1,1,2,3,4,5,6,7
and NOT the required 1,2,3,4,5,6,7
Why? Thanks, k.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Dan - thanks but
438 Error - Object doesn't support this property or method.
438 Error - Object doesn't support this property or method.
It does on Excel 2013.
ASKER
I have Excel 2000. :(
Well, someone at Microsoft will be happy about the next question: maybe it's time to upgrade? :)
ASKER
Yeah . . . s/one at MS is always happy I'd reckon. ;)
The fact is I'd already written my own (very long, but effective) de-dupe routine, but as it's in a sub with a load of other stuff, I wanted to make a new sub - which also will need a de-dupe routoine too -, less busy by using this AdvancedFilter option. Now that I see I can't, I'll have to use my own again. But even *that* leaves a bitter taste, as, like you said, it's all redundant if one has 2013.
The fact is I'd already written my own (very long, but effective) de-dupe routine, but as it's in a sub with a load of other stuff, I wanted to make a new sub - which also will need a de-dupe routoine too -, less busy by using this AdvancedFilter option. Now that I see I can't, I'll have to use my own again. But even *that* leaves a bitter taste, as, like you said, it's all redundant if one has 2013.
This says that the RemoveDuplicates method is available since Excel 2007.
ASKER
Yup. But as I said, I have Excel 2000.
ASKER
What's more, the field header will end up in any copying of the data that I do, and I do not want that at all.
I'd go so far as to say that IMO it's one of the most ridiculous and application-defeating, lame functions I've yet seen in Excel. The fact that the Filter function has no optional header exclusion parameter is beyond belief.