Advanced Filter Case Sensitive

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")


Joseph S Johnson wrote:
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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

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.
-----Original Message-----
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 wrote:
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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

.

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).

Joseph S Johnson wrote:
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.

-----Original Message-----
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 wrote:

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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

.




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

=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

"Joseph S Johnson" wrote in message
...
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.
-----Original Message-----
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 wrote:
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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

.