Advanced Filter Wildcard

[tpeter]

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

 

[Bernie Deitrick]

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]

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