In DATABASE criteria "Blank Cell" AND ="" are NOT the same things??

damlays

New member
Joined
Sep 27, 2015
Messages
3
Reaction score
0
Points
0
In DATABASE criteria "Blank Cell" AND ="" are NOT the same things??

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.
(As seen clearly at attached file)


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?
 

Attachments

  • ExcelDatabaseProblem.JPG
    ExcelDatabaseProblem.JPG
    45.9 KB · Views: 14

damlays

New member
Joined
Sep 27, 2015
Messages
3
Reaction score
0
Points
0
About Cross-posting issue;As I know; If I post same question in different sections of the SAME FORUM it is cross posting and wasting time of people.But,Again as I know; There are several forums Separate and Independent from each other, and their readers are not completely same.Why I cannot post the same question into different platforms freely?I cannot understand this point well.Are they in reality only one forum (or one organization) but under different domain names?Am I missing any point?
 

NoS

New member
Joined
Jan 17, 2013
Messages
832
Reaction score
0
Points
0
Location
British Columbia
Excel Version(s)
Excel 2010
Congratulations damlays.

No one could have verified your neglect of reading the rules of the various forums as well as you have.
 

Pecoflyer

Admin Alumnus
Joined
Oct 13, 2011
Messages
1,769
Reaction score
0
Points
36
Location
Brussels Belgium
Excel Version(s)
2010 on Xubuntu - O365
Congratulations damlays.

No one could have verified your neglect of reading the rules of the various forums as well as you have.


+1 to that. And there are some other links the OP didn't bother to provide here...
 
Top