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
|