| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel filter
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel filter
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel filter
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? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel filter
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? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel filter
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? |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel filter
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 "Teethless mama" wrote in message ... 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel auto-filter does not filter certain columns | Excel Discussion (Misc queries) | |||
| DataFilterAuto Filter in excel 2007? | New Users to Excel | |||
| Excel 2007 Auto Filter Filter | Excel Discussion (Misc queries) | |||
| Filter PivotTable dropdown items to match report filter | Excel Discussion (Misc queries) | |||
| Excel auto filter doesn't recoginize case - won't filter AA from A | Excel Discussion (Misc queries) | |||
Hybrid Mode
