If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
Advanced Filter Case Sensitive
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 |
#3
|
|||
|
|||
Advanced Filter Case Sensitive
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 . |
#4
|
|||
|
|||
Advanced Filter Case Sensitive
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 |
#5
|
|||
|
|||
Advanced Filter Case Sensitive
=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 . |
Thread Tools | |
Display Modes | |
|
|