In DATABASE criteria "Blank Cell" AND ="" are NOT the same things?? I couldn't find any solution to this simple point yet !

[damlays]

As known, when criteria cell is EMPTY excel IGNOREs that Criteria.


BUT, the problem is;
- If criteria cell is really BLANK, excel really (totally) ignores that criteria
- If criteria cell is BLANK with FORMULA (as ="" ), then excel ignores that criteria again, BUT this time NOT COUNTING "the ROWS with blank cells" in database table.


Problem is a simple point, but solution is not found yet:
According to Excel's reading, the Difference Between "Blank Cell" & "Null Text" is causing this problem in Criteria Cell.


I am looking for any excel expression which TELLS to Excel to read that Cell as "Blank Cell"
Is there any way to do it?

 

[damlays]

If sharing link is important, then,
Please find my same posts below;
(PS. I still cannot get answer of the original question in any forum)


In DATABASE criteria "Blank Cell" AND ="" are NOT the same things?? • ExcelKey.com - Free Excel Help
In DATABASE criteria "Blank Cell" AND ="" are NOT the same things?? I couldn't find any solution to this simple point yet ! | ExcelExperts.com
In DATABASE criteria "Blank Cell" AND ="" are NOT the same things??
In DATABASE criteria "Blank Cell" AND ="" are NOT the same things??
http://www.mrexcel.com/forum/excel-...ny-solution-simple-point-yet.html#post4292993

 

[Aladin Akyurek]

I could not post my attachment here and maybe I could not tell what I mean very successful.

I port this also to
In DATABASE criteria "Blank Cell" AND ="" are NOT the same things?? • ExcelKey.com - Free Excel Help

with attachment.

If you can check my jpg file there, point is very clear shown.

Just answer the questions you are posed instead of posting yet another link...

 

[ukmikeb]

I could not post my attachment here and maybe I could not tell what I mean very successful.

I port this also to
In DATABASE criteria "Blank Cell" AND ="" are NOT the same things?? • ExcelKey.com - Free Excel Help

with attachment.

If you can check my jpg file there, point is very clear shown.

If one is not a member of that forum then one is prevented from viewing the files in that forum. Many of the Forums use that approach.

If you want to share a file use Dropbox or any of the other file sharing sites.