Working with Blank cells

[DashboardNovice]

I ran a report from the web and had it rendered in Excel. This downloads in the same style as a Pivot Table, in that it has many blank cells, or maybe I should say many apparent blank cells.

In order to test for the "blankness" of a cell I applied the ISBLANK function on column B which has "blank" cells and it returned FALSE. Then I applied an AutoFilter to column B. On the drop down menu, I selected the checkbox called (Blanks) and it filtered for all blank cells.

So the ISBLANK function indicates that the cells in column B are not blank. But when I used the AutoFilter and selected "(Blanks)" this seems to imply that the AutoFilter recognizes these cells in column B as being blank.

So what is going on here? And how is a blank cell defined?

 

[p45cal]

see:
http://office.microsoft.com/en-gb/e...-formulas-to-additional-rows-HP005229125.aspx

 

[bobhc]

The search box does work, of late, this is a much asked question, all be it in slightly different terminology, have a look at this thread and scroll to the last reply.

http://chandoo.org/forum/threads/sum-function-not-working-on-some-cells.17280/


.

 

[p45cal]

see:
http://office.microsoft.com/en-gb/e...-formulas-to-additional-rows-HP005229125.aspx

Sorry, I answered in the wrong thread!