Auto Filter
 

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

Auto Filter
 

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

Hope this helps.

Pete

On Nov 24, 2:30 pm, stremetzky wrote:
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

Auto Filter
 

It doesn't change. :(

Thank you anyway.
stremetzky

Auto Filter
 

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 wrote:
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


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Auto Filter
 

On Nov 24, 5:43 pm, Debra Dalgleish wrote:
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 wrote:
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 useAutofilter, Custom, Contains, 18

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

stremetzky

--
Debra Dalgleish
Contextureshttp://www.contextures.com/tiptech.html

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