Excel 2016 Data Filter bug

Question

I am not sure if anyone else has experienced this issue.

I am working with Excel 2016. I'm working with small amount of data, precisely 2662 records (lines). I have a column (G) called Has Breach with True or False values.

When I filter for False values, at the bottom left corner of Excel (highlighted in red), it says 2311 of 2662 records found. However, at the bottom right corner of an Excel, when I count the number of items in column A or G), the Count returns 2310 records when I highlight all the filtered items.

Answer 1

I'm pleased to hear that it works.

Would you please so kind and mark the post as answered? Thank you.

Andreas.

Answer 2

The issue is row 19 in your file, because the row height is 0. Do as follows:

Remove the Autofilter

Select rows 18:20

Right-click and set the row height to 20

Apply the Autofilter

After that the count is the same as the number of filtered items.

Andreas.

Answer 3

Hi Andreas,

i do not have a dropbox account. i have uploaded sample data here. I hope this helps. I have not seen or identified white spaces. the first column (A) is unique. Has breach column has true or false data. it will be interesting to know if it's not a bug.

https://drive.google.com/drive/folders/1oNj5ycdNcILFjgIojJCR5Pdvaj64gKiR?usp=sharing

thanks for replying.

Answer 4

This does not have to be a bug, it is possible that one of your selected cells contains a "null string" or something similar and this cell is not counted.

Please check your result by selecting the same cells in the filtered column. I guess you'll see the same number in that case.

If you need further help please upload your file (maybe with anonymous data) on an online file hoster like www.dropbox.com and post the download link here.

A macro to anonymize data in selected cells can be downloaded here:

https://www.dropbox.com/s/rkfxuh85j5wyj9y/modAn...

Andreas.

Answer 5

I would suggest you to leave your comments to the team.

Here are you options to leave a feedback:

Give feedback on Microsoft Office

https://support.office.com/en-us/article/how-do...