advanced filter

[kkondrat1]

hello,

I am currently using an advanced filter, I have a list of "ten digit"
ID #'s( they are the key to the row data.) and other data that goes
with them.

I want to select all the rows that contain an "808" in the ten digit ID
field.

for example:

ID# pet age
8089878767 puppy 12
7895584747 cat 10
8089548373 bird 11


I want all the rows that contain an "808" to be returned.

I tried to set my criteria up like:

ID# ID#

=8080000000 <=8089999999

I'm not sure why this doesn't work, when i run the filter it returns
nothing.

Please help, Thanks

 

[Bill Kuunders]

You could use the autofilter.
click on the dropdown for ID#s
select custom and add your conditions
select the conditions using the drop downs again.

Regards
Bill K

 

[JMay]

I Suppose your ID# is a Text string or formatted Text,
With Criteria Range set to F1:F2 where F1 = ID# and F2 =
808*
It worked for me..
HTH

 

[kkondrat1]

Thanks JMAY, PERFECTO!