Advance Filtering

Hello Elaine,


Thank you for your question regarding Advanced filtering.

As you may have done on the course, the advanced filtering in Excel gives you more possibilities of creating complex multi criteria filtering. You are correct in thinking it gives you AND logic, but also OR logic too. So you can create a filter that looks for e.g. people who are over 50 AND live in a big house AND spend more than 100 pounds OR live in a small house!

Once set up, its easy to just type these arguments in the boxes (cells).

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Mark
Microsoft Office Specialist Trainer