Auto Filter

  • Thread starter Thread starter stremetzky
  • Start date Start date
S

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
 
Try adding a comma (or <comma><space>) after the 18 in your custom
filter box.

Hope this helps.

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

Select OR as the operator
For the second test enter:
Contains: , 18
 
In a Custom filter, for the first test enter:
Begins with: 18

Select OR as the operator
For the second test enter:
Contains: , 18
Click to expand...

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