PDA

View Full Version : Solved: Case Sensitive Advanced Filter



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.

Norie
08-29-2006, 08:16 AM
Neil

You'll probably need to use a helper column to identify the rows to delete.

Can you post some sample data and more details on what you actually want to do?

Belch
08-29-2006, 08:42 AM
Hi Norie,
Don't worry about it, I've done a workaround for it - it was only happening with specific data (strings beginning with a lowercase e, s or t) so all I've done is replace those letters with %e%, %s% etc so they are unique.
Then once the AdvancedFilter method is done I remove the % signs.

It's a roundabout way of doing it but it works and doesn't appear to add much time to the routine. Plus I'm short of time for it so can't afford to look into better ways.

Thanks anyway,