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?