Advanced Filter - EXACT text match only

[Raysoc]

I am advanced filtering on a set of data. Data resides in columns A-J, in L i put the column heading and below I put the three criteria I want. However when I filter it pulls the three criteria and ANY criteria that begins with one of them also.

For example. Criterias are. A, B, C. But if a value is CZ then it pulls all C and CZ, I want it to ONLY pull exact matches not just if it starts with that.

Thanks!

 

[sailepaty]

Instead of only A use ="=A" on your criteria.

Regards

 

[Raysoc]

Perfect, thanks!

Why does that work tho?

Also is there a way of filtering based on comparing a date?

In column C is a creation date, D is an effective date. I only want rows where D is >30 days from the creation date..

Thanks!

 

[sailepaty]

Best place to learn Advance filters.

http://www.contextures.com/xladvfilter01.html

Regards