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" <(E-Mail Removed)> wrote in message
news:1191201c441c1$b2096430$(E-Mail Removed)...
> 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
> >
> >.
> >