Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filtering
dear all,
I want to filter data existing in my worksheet based on more than one criteria the same like in Auto filter but with some difference for example: I have 2 columns , Car Brand (Manufacturer) and Car Model with Auto filter I want when drilling down on Car brand in first column display only the car models in the selected car brand as if its like a tree 2nd column depends on 1st , 3rd depends on 2nd ..etc and as if am refining data step by step thnx, Khaled |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filtering
Add a formula in an other column, =A2&B2, copy down, and then filter on that
new column -- --- HTH Bob (change the xxxx to gmail if mailing direct) "khaled shaheen" wrote in message ... dear all, I want to filter data existing in my worksheet based on more than one criteria the same like in Auto filter but with some difference for example: I have 2 columns , Car Brand (Manufacturer) and Car Model with Auto filter I want when drilling down on Car brand in first column display only the car models in the selected car brand as if its like a tree 2nd column depends on 1st , 3rd depends on 2nd ..etc and as if am refining data step by step thnx, Khaled |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filtering
Filter and AutoFilter are good, but you need to use the Outline feature.
See Outline in Excel Help -- Gary's Student "khaled shaheen" wrote: dear all, I want to filter data existing in my worksheet based on more than one criteria the same like in Auto filter but with some difference for example: I have 2 columns , Car Brand (Manufacturer) and Car Model with Auto filter I want when drilling down on Car brand in first column display only the car models in the selected car brand as if its like a tree 2nd column depends on 1st , 3rd depends on 2nd ..etc and as if am refining data step by step thnx, Khaled |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filtering slows down a macro | Excel Worksheet Functions | |||
Advance filtering with multiple conditons | Excel Discussion (Misc queries) | |||
Row filtering based on input box entry (column heading) | Excel Worksheet Functions | |||
trouble filtering a list. Why isn't column filtering? | Excel Worksheet Functions | |||
avanced filtering for latest date | Excel Discussion (Misc queries) |