Belch
08-29-2006, 07:14 AM
Hi all,
I'm using the AdvancedFilter method to remove duplicate values appearing in one column.
The problem is, I need it to be case sensitive as the value "E020" and the value "e020" should be classed as different, but AdvancedFilter doesn't see it this way.
I've had a look at the help stuff for AdvancedFilter and I'm guessing there's no simple way to do it. Does anyone know of a way to do it, or a more efficient way of removing duplicate data?
Thanks in advance.
I'm using the AdvancedFilter method to remove duplicate values appearing in one column.
The problem is, I need it to be case sensitive as the value "E020" and the value "e020" should be classed as different, but AdvancedFilter doesn't see it this way.
I've had a look at the help stuff for AdvancedFilter and I'm guessing there's no simple way to do it. Does anyone know of a way to do it, or a more efficient way of removing duplicate data?
Thanks in advance.