Advanced Filter Wildcard

  • Thread starter Thread starter tpeter
  • Start date Start date
T

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)
Click to expand...

Thank you for your help.

Tim Peter
 
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
 
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
 
Back
Top