Results 1 to 3 of 3

Check if the cells are not blank

Threaded View

  1. #1
    Registered User
    Join Date
    12-11-2012
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    2

    Check if the cells are not blank

    I have attempted to alter this example to simply check if the cells are not blank by replacing the "X" with "<>", but I get errors in the SMALL function--it looks like the IF statement is just returning an array with all of the values set to FALSE, and none of the values in the array call out a location of the next filled cell.

    How could you alter your fixed XLSX file to check for non-blank cells instead of "X" specifically?

    Thanks,

    Micah
    Last edited by mkgoff11; 12-19-2012 at 02:11 PM. Reason: Added link to url

Thread Information

Users Browsing this Thread

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

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