Glide Training

September 2016

Excel Advanced Filter – find records with blank cells

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.find records with blank cells with advanced filter

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).:find records with blank cells with advanced filter

I am now ready to run my advanced filter as shown here:find records with blank cells with advanced filter

Here are my results:find records with blank cells with advanced filter

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.

-->

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.find records with blank cells with advanced filter

Read more on Excel Advanced Filter – find records with blank cells…