Results 1 to 6 of 6

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

  1. #1

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



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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?
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	ExcelDatabaseProblem.JPG 
Views:	12 
Size:	45.9 KB 
ID:	3966  

  2. #2

  3. #3
    Wizard Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,615
    Articles
    0
    Excel Version
    2010 on Xubuntu

  4. #4
    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?

  5. #5
    Magician NoS's Avatar
    Join Date
    Jan 2013
    Location
    British Columbia
    Posts
    751
    Articles
    0
    Excel Version
    Excel 2010 64bit
    Congratulations damlays.

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

  6. #6
    Wizard Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,615
    Articles
    0
    Excel Version
    2010 on Xubuntu
    Quote Originally Posted by NoS View Post
    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...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •