Excel filter

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?
 
A

Ashish Mathur

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
 
S

Sudipta Sen

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.
 
A

Ashish Mathur

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
 
T

Teethless mama

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
 
A

Ashish Mathur

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top