Thread: Auto Filter
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default 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