Not showing blank and non blank items in filter mode for values

B

Bhaskar Polisetty

On Filtering the below list, we are not able to get the filter for blanks
even though there are blank data available. however, filtering by Custom =
Blanks, we are able to get the data Why is it that blank category and Non
blank category not appearing in the filter????

When there are series of values are listed and when you filter the values,
there if there are any blanks are there between the lines, then excel filter
is not showing those blank line items.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top