You cannot use custom filters here because you have more than 2 conditions.
You will have to use Advanced filters as described in my previous post

Why bother with Advanced filters, you can use with AutoFilter and select BB,
CC, and EE


"Ashish Mathur" wrote:

Hi,

You cannot use custom filters here because you have more than 2 conditions.
You will have to use Advanced filters as described in my previous post

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Sudipta Sen" wrote in message
...
Thks 4 ur co-operation.

Just I want to filter datas from the list in the same place where datas
are.
means : by the customs option in the filter list. Actually by the help of
customs (And / or) I could filter only two type of datas, but want to do
more. So pls help me to get the datas from the automatice filter - filter
name - customs option.

"Ashish Mathur" wrote:

Hi,

Suppose the data is in range B3:C9. In B2, enter names and in C2, enter
numbers. In B11, enter names and in B12, B13 and B14, enter BB, CC and
EE.
Now go to Data Filter Advanced Filter. In action, select, filter the
list in place. In list range, give the range as B2:C9. In criteria,
give
the range as B11:B14. Now click on OK. You will see only those rows
which
have BB, CC and EE.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Sudipta Sen" <Sudipta wrote in message
...
I want to filter more that two type of data from my list. eg.
AA 10
BB 20
CC 30
DD 40
EE 50
AA 60
BB 70

Now I have to filter only BB, CC & EE, How I could do it?