Filtering

[jhelliar]

I have data which I want to be able to filter but I want it to filter more than one column at a time. Is this possible? I have included a worksheet to show what I mean. I can manage to filter one column but not more than one simulataneously.

[jhelliar]

Is it possible to do this without vba?

[arthurbr]

Is it possible to do this without vba?

Yes, it is.
Use advanced Filter in the data menu.
For more explanations serach XL's help for " advanced filter" and use the tips under Multiple criteria in multiple columns where any criteria can be true

Cheers

[jhelliar]

thank you. that makes it a lot easier

[arthurbr]

You're welcome Thx for the feedback