Written by Jane Hames
On an Excel course this week, I was asked how to apply an advanced filter to show records that contain some blank cells. This is something that isn’t very obvious, but if you know how to use the advanced filter in Excel, you will find it very easy! Here’s a snippet of my data which does have a couple of records which are missing some data.
I have created a criteria range below my data. I want to filter for any records which have EITHER the Customer or the Book cell blank. In the image below, you can see that I have entered the = below the customer and the book headings. (The = are on different rows to make this an OR filter).:
I am now ready to run my advanced filter as shown here:
Here are my results:
If you would like to learn how to use the Advanced Filter from scratch or just to learn more about Excel please do get in touch.