+ Reply to Thread
Results 1 to 3 of 3

counting blank cells in range based on condition using another column

  1. #1
    Registered User
    Join Date
    09-14-2013
    Location
    United Kingdom
    MS-Off Ver
    Excel 2007
    Posts
    2

    counting blank cells in range based on condition using another column

    I'm importing and validating a number of data sheets. First thing I want to do is simply make sure there's no missing data and there isn't data where there shouldn't be. Most sheets are simple countblanks on specific columns but I now need to do it based the value of another cell.

    For example, where the first column contains B or C, the remaining columns must have data, where the first column has no value only the second one should have a value. Countifs look to be out of the question due to the different possible data values and the number of columns to check.

    Is autofilter the way to go, followed by countblank on the columns as necessary? Feels like there is more elegant way. I'm trying to avoid coding loops so I can leverage the speed of the build in functions.

    B X X X X
    C X X X X
    X
    B X X X X
    X
    X
    X

    Thanks

  2. #2
    Registered User
    Join Date
    11-05-2012
    Location
    Denmark
    MS-Off Ver
    Excel 2010
    Posts
    61

    Re: counting blank cells in range based on condition using another column

    I get the data validation, but what is the outcome that you seek? delete row? a simle "yes" somewhere in the sheet?

  3. #3
    Registered User
    Join Date
    09-14-2013
    Location
    United Kingdom
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: counting blank cells in range based on condition using another column

    A simple count is fine as it will just be used to decide whether to carry on with validation.

    Thanks

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Counting the number of empty cells based on a condition in a range
    By naga in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-01-2013, 10:01 AM
  2. [SOLVED] Counting cells that fall in a date range AND meet a Yes/No condition
    By pentatonic145 in forum Excel General
    Replies: 2
    Last Post: 05-01-2012, 04:26 PM
  3. Replies: 3
    Last Post: 08-07-2009, 12:03 PM
  4. Replies: 5
    Last Post: 08-05-2009, 02:43 PM
  5. Replies: 0
    Last Post: 08-23-2005, 03:43 AM

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