Results 1 to 9 of 9

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

Threaded View

  1. #1
    Registered User
    Join Date
    12-14-2003
    Posts
    4

    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?
    Attached Images Attached Images
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 4
    Last Post: 11-17-2013, 12:05 PM
  2. [SOLVED] How to USE """"" cells count """"" change font color
    By austin123456 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-09-2013, 06:14 AM
  3. solution for the blank cell using the IF function
    By ragnaedge in forum Excel General
    Replies: 4
    Last Post: 08-23-2013, 11:03 AM
  4. [SOLVED] Test for blank cell should be "True" but "False" action is taken.
    By Aceso in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 02-09-2013, 05:47 PM
  5. Replies: 8
    Last Post: 12-31-2012, 05:19 PM
  6. Replies: 3
    Last Post: 02-16-2011, 02:55 PM
  7. Replies: 0
    Last Post: 07-09-2009, 04:07 PM
  8. Replies: 3
    Last Post: 12-14-2006, 01:36 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1