Advanced Filter Case Sensitive

[Joseph S Johnson]

Hi, Is there any way to make an advanced filter case
sensitive? For example, I want to type DOG in the criteria
range and run the filter and only pull records that are
DOG, not dog. Thanks very much.

 

[Debra Dalgleish]

In the criteria area, leave the heading cell blank
In the cell below, enter a formula that refers to the first row of data.
For example:

=EXACT(D2,"DOG")

 

[Joseph S Johnson]

Thank you very much. You helped me a little. I was a bit
vague when I first asked my question. Your technique
works, but I need to be able to pull for multiple
criteria...in other words, not just "PET = DOG", but
also "State = NJ" I can use your method on just one field,
but not several fields. Thanks though.

 

[Debra Dalgleish]

Add more columns to the criteria, and write formulas for the additional
fields. Put all the criteria on the same row, if all conditions must be
met (e.g. Pet=DOG AND State=NJ), or on different rows if only one of the
conditions must be met (e.g. Pet=DOG OR State=NJ).

 

[Peo Sjoblom]

=AND(EXACT(D2,"DOG"),EXACT(E2,"NJ"))



=OR(EXACT(A5,"DOG"),EXACT(B5,"NJ"))

--


For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom