How to filter in many criteria?

Dear Expert,

I have a workbook uploaded based on the center washing machine.

Could you guide me on how to filter more than 1 criterion as I have shown at the workbook "Expected Results Shows after filter"?
I have tried the excel -> data -> advanced data but it can only show 1 data which my management is looking for more than 1 criteria range.

Hope to hear from you.

Thank you.

Hi bebo021999,

There is a catch, the expected results that our management want to know is without Boston - LG under Quarantine.

So, do you have any other idea?

Thanks.

Just filter " quarantine" out in the Status column

Hi, arthurbr,

Thanks for the simple filter.

I have uploaded the same workbook but this time I have added a few rows as I key in into the table.

Could you filter the same Expected Results?

Hope to hear from you soon.

It's all quite easy. Open each filter in turn (click the arrow in the header) and check the items you want to display in your filtered data

Dear GeoffW283,

Thanks for your concern. Yes, order matters.

If I am using your method to filter "location" and "status" to exclude only "Quarantine", it doesn't work as the following below need to be excluded as well.


New York Panasonic Repair
Boston Moyo New Centre
New York LG New Centre

Do you have any other ideas or functions or formula to filter only the expected results as shown in the workbook?

Kindly advise with thanks.

That is a Brilliant idea, GeoffW283!

Thank you very much.