K
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#
I'm not sure why this doesn't work, when i run the filter it returns
nothing.
Please help, Thanks
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