Excel filter

  • Thread starter Thread starter Sudipta Sen
  • Start date Start date
S

Sudipta Sen

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?
 
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
 
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.
 
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
 
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
Click to expand...

Why bother with Advanced filters, you can use with AutoFilter and select BB,
CC, and EE
 
This can happen in Excel 2007 only (where you can select multiple items in
the drop down filter box. In Excel 2003 and prior versions, you can only
make one selection at a time

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
 
Back
Top