+ Reply to Thread
Results 1 to 4 of 4

count number of Simultaneous blanks

  1. #1
    Registered User
    Join Date
    12-12-2012
    Location
    Norway
    MS-Off Ver
    Excel 2007
    Posts
    3

    count number of Simultaneous blanks

    Hi I would Like to count the number of simultaneous blanks in a Row
    For eg: I have 3 columns A B C.
    Now I want to know the instances of
    a) 3 blanks together
    b) cells having text value U and T (among value of U ,T and H)

  2. #2
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: count number of Simultaneous blanks

    a) 3 blanks together
    =COUNTBLANK(A1:C1)=3
    copied down

    b) cells having text value U and T (among value of U ,T and H)
    Please elaborate further. Perhaps a sample worksheet with desired results...
    Life's a spreadsheet, Excel!
    Say thanks, Click *

  3. #3
    Registered User
    Join Date
    12-12-2012
    Location
    Norway
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: count number of Simultaneous blanks

    For b) I am getting false for every combination?

    I will elaborate on the question further

    3 Columns----Each cell can take values either U or T or H or remain Blank.

    I want to count the number of instances where entire row is blank
    number of instances where row has U in 1st column and T in 3rd column

    hope that helps?

  4. #4
    Forum Expert icestationzbra's Avatar
    Join Date
    01-07-2004
    MS-Off Ver
    2007, 2010
    Posts
    1,421

    Re: count number of Simultaneous blanks

    see if this helps:
    Attached Files Attached Files
    - i.s.z -
    CSE, aka Array aka { }, formulae are confirmed with CONTROL+SHIFT+ENTER.
    Replace commas ( , ) with semicolons ( ; ) in formulae, if your locale setting demands.
    All good ideas are courtesy resources from this forum as well as others around the web.
    - e.o.m -

+ 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