Advanced Filter Wildcard
 

I have an advanced filter setup so I can look at a range of data. My problem
is the wildcard caracters do not work, it still wants exact numbers. An
example is:


=0j705641 <=0j705643 ( this works)
=*705641 <=*705643 (this doesn't)

Thank you for your help.

Tim Peter

Advanced Filter Wildcard
 

Use a column of helper formulas, like

=AND(VALUE(RIGHT(A2,6))=705641, VALUE(RIGHT(A2,6))<=705643)

and copy down, then use TRUE to filter based on your column of formulas.

HTH,
Bernie
MS Excel MVP


"tpeter" wrote in message
...
I have an advanced filter setup so I can look at a range of data. My problem
is the wildcard caracters do not work, it still wants exact numbers. An
example is:


=0j705641 <=0j705643 ( this works)
=*705641 <=*705643 (this doesn't)

Thank you for your help.

Tim Peter

Advanced Filter Wildcard
 

Bernie,

Sorry it took me so long to get back. Thank you for your response, with a
couple of tweaks (instead of using 705641 I changed it to my criteria cells)
everything worked great. I would have never thought of using true false
statments for this application but it worked well. Thank you again for your
assistance.

Tim Peter

"Bernie Deitrick" wrote:

Use a column of helper formulas, like

=AND(VALUE(RIGHT(A2,6))=705641, VALUE(RIGHT(A2,6))<=705643)

and copy down, then use TRUE to filter based on your column of formulas.

HTH,
Bernie
MS Excel MVP


"tpeter" wrote in message
...
I have an advanced filter setup so I can look at a range of data. My problem
is the wildcard caracters do not work, it still wants exact numbers. An
example is:


=0j705641 <=0j705643 ( this works)
=*705641 <=*705643 (this doesn't)

Thank you for your help.

Tim Peter