+ Reply to Thread
Results 1 to 3 of 3

Formula to compare if multiple cells no longer blank

  1. #1
    Registered User
    Join Date
    09-07-2009
    Location
    Lytham, England
    MS-Off Ver
    Excel 2003+07
    Posts
    75

    Formula to compare if multiple cells no longer blank

    Hi,

    I need to check if any cells are no longer blank...

    Basically I will be checking if corresponding cells in say columns ABC are no longer blank in columns DEF.

    My intital way of going it was to do something along these lines...

    =IF(AND(ISBLANK(A1)=TRUE,ISBLANK(D1)=FALSE),1,0)

    and I was then going to surround this with another AND statement for cols Bs and Cs.

    Unfortunately the way I'm implelmenting this will make the formula to long (I will be building the solution into an array formula to ultimately count all the rows where one column was blank and is no longer in it's corresponding column).

    Apologies if I have over-complicated what I'm trying to do-I have put below a quick example.

    Columns ABC headed Dog Cat Fish for 2009 and Columns DEF headed Dog Cat Fish for 2010.
    Each row relates to if a person had one of the pets in each year and also what type Jack Russell etc.

    In my overall forumula I want to count the number of people that now have a new pet category in 2010 that didn't in 2009. i.e. no Dog 2009 but now has one 2010. I'm not concerned if they had a dog in both years but the dog type changed...

    If any of the columns was blank for 2009 but not for 2010 I want to count it as 1.

    Ideally I want to do this without using any other formulas in other cells which I appreciate does complicate things...

    Your thoughts/suggestions are really welcome.

    Cheers
    Last edited by pdauction; 04-21-2011 at 08:31 AM.

  2. #2
    Forum Guru (RIP) Marcol's Avatar
    Join Date
    12-23-2009
    Location
    Fife, Scotland
    MS-Off Ver
    Excel '97 & 2003/7
    Posts
    7,216

    Re: Formula to compare if multiple cells no longer blank

    Is this something like this what you have in mind?
    Attached Files Attached Files
    If you need any more information, please feel free to ask.

    However,If this takes care of your needs, please select Thread Tools from menu above and set this topic to SOLVED. It helps everybody! ....

    Also
    اس کی مدد کرتا ہے اگر
    شکریہ کہنے کے لئے سٹار کلک کریں
    If you are satisfied by any members response to your problem please consider using the small Star icon bottom left of their post to show your appreciation.

  3. #3
    Registered User
    Join Date
    09-07-2009
    Location
    Lytham, England
    MS-Off Ver
    Excel 2003+07
    Posts
    75

    Re: Formula to compare if multiple cells no longer blank

    Yes I think you're right with that, makes sense to add an extra column with formulas. Many thnaks for your help...

+ Reply to Thread

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