Advanced Filter Case Sensitive

  • Thread starter Thread starter Joseph S Johnson
  • Start date Start date
J

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.
 
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")
 
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.
 
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).
 
=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
 
Back
Top