R
Radon
I've trying to use the AdvancedFilter function from VBA but I'm having
problems... I have a table w/ several rows. I want to eliminate any duplicate
row. I don't want to eliminate based on any column being the same. The
criterion is that the entire row has to match another row in order to be
removed.
What I've noticed is that Excel doesn't always know whether it should
eliminate duplicate rows vs. columns. I've tried simply creating a header
that "looks" different than the data and the AdvancedFilter function seemed
to work better.
Is there a way for me to specify in the AdvancedFilter function that only
entire matching rows should be eliminated? Would that be in the Criteria
field?
Regards.
problems... I have a table w/ several rows. I want to eliminate any duplicate
row. I don't want to eliminate based on any column being the same. The
criterion is that the entire row has to match another row in order to be
removed.
What I've noticed is that Excel doesn't always know whether it should
eliminate duplicate rows vs. columns. I've tried simply creating a header
that "looks" different than the data and the AdvancedFilter function seemed
to work better.
Is there a way for me to specify in the AdvancedFilter function that only
entire matching rows should be eliminated? Would that be in the Criteria
field?
Regards.