Results 1 to 10 of 10

total count of non-blank cell(s) and unique values

Threaded View

  1. #1
    Registered User
    Join Date
    04-28-2010
    Location
    TX
    MS-Off Ver
    Excel 2007
    Posts
    5

    total count of non-blank cell(s) and unique values

    Good afternoon - I have the spreadsheet bleow (it's also attached for better layout), and what I want it to get is the total count of non-blank cell from the answer(column B) and only count the answer once for those users that are listed multiple times (columnA).So my total count fro ColumnB should be 18. Please let me know how can I accomplish this.
    Thank you in advance!

    User Answer
    JOSE Yes
    MARIA No - Other Reason
    MARY No - Other Reason
    SHERYL K No - Other Reason
    VIGGO J No - Other Reason
    IGNACIO No - Other Reason
    ISAAC No - Other Reason
    LAURA Yes
    GUADA No - Other Reason
    MERIC No - Other Reason
    JUAN No - Other Reason
    OLGA No - Other Reason
    ARTHUR Yes
    CARLA Yes
    JOAN No - Other Reason
    LILLIE Yes
    LILLIE Yes
    DOROTHY No - Other Reason
    JOHN C
    PABLO No - Other Reason
    PABLO No - Other Reason
    PABLO No - Other Reason
    Attached Files Attached Files
    Last edited by NBVC; 06-09-2010 at 01:54 PM.

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