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
|