+ Reply to Thread
Results 1 to 3 of 3

Checking if multiple cells are blank

  1. #1
    Registered User
    Join Date

    Checking if multiple cells are blank


    I have a worksheet with Account numbers in column A. An account number can appear in this column more than once (more than one record per account).

    I need to check if Column C is blank for all records on that account. Is there any way to do this.

    Basically if the cell in C is blank then that record is inactive. I am trying to identify if an account has any active records.

    Thanks in advance for any help you can provide.

  2. #2
    Forum Contributor
    Join Date
    Suffolk, UK
    Try this,

    in E1 type

    Please Login or Register  to view this content.
    A1:A100= your account name list
    D1 = account name
    C1:C100= record list

    it looks for each individual account and counts the times there is an active cell, so any 0 results would have no active records for that account.

    hope it helps reg

  3. #3
    Forum Expert
    Join Date

    Check for inactive accounts

    Here is one option (see encl.).
    Provided as a Single Account Information or an All Accounts list
    Attached Files Attached Files

+ 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. Removing blank cells
    By eclipsenetworkz in forum Excel General
    Replies: 2
    Last Post: 05-16-2008, 07:49 PM
  2. Calculating percentages-how to ignore blank cells?
    By lemoineer in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-21-2008, 08:46 PM
  3. Counting occurence of multiple cells containing data
    By BrakZak in forum Excel General
    Replies: 8
    Last Post: 11-08-2007, 09:52 AM
  4. Excel doesn't think blank cells are not really blank?
    By leonnord in forum Excel General
    Replies: 3
    Last Post: 08-01-2007, 02:34 PM
  5. Blank Cells Plotting as Zeros
    By ChristiaanV in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 12-13-2006, 11:31 PM


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