Auto Filter

[stremetzky]

My cells include numbers in following format:

cell A1: 1, 14, 18, 34,
cell A2: 5, 22, 45,
cell A3: 1, 118, 150,
....

I want to filter cells to those which contain 18.
I use Autofilter, Custom, Contains, 18

But it doesn't filter A3, I guess because it contains 118. How can I
filter it to exact number?

stremetzky

 

[Pete_UK]

Try adding a comma (or <comma><space>) after the 18 in your custom
filter box.

Hope this helps.

Pete

 

[stremetzky]

It doesn't change.

Thank you anyway.
stremetzky

 

[Debra Dalgleish]

In a Custom filter, for the first test enter:
Begins with: 18

Select OR as the operator
For the second test enter:
Contains: , 18

 

[stremetzky]

In a Custom filter, for the first test enter:
Begins with: 18

Select OR as the operator
For the second test enter:
Contains: , 18

I managed to solve it. I've put the data in the cell in the following
format:

cell A1: ,1,14,18,34,
cell A2: ,5,22,45,
cell A3: ,1,118,150,

than I use Autofilter, Custom, Contains, ",18,"

Thank you for help!

stremetzky