+ Reply to Thread
Results 1 to 3 of 3

Count how many unique name are true

  1. #1
    Registered User
    Join Date
    06-01-2016
    Location
    United States
    MS-Off Ver
    MAC OS 2011
    Posts
    1

    Count how many unique name are true

    Hello,
    I just signed up and I need some help with a formula i'm trying to create with a large table.

    It is laid out like so:

    Please Login or Register  to view this content.
    The Customer Name column will have many duplicate values, because the middle columns have different values. The "Outcome" column will be either 'TRUE' or 'FALSE' for each difference "web address" in the table.

    What I want to do is check if unique "Customer Name" has any 'TRUE' values in the "Outcome" column and make a count.
    This way it's not counting how many 'TRUE' there is for each customer and summing them up, but giving a BOOLEAN statement of 'TRUE' if ANY "Outcome" Column value is TRUE for any UNIQUE Customer name.

    Example:

    Please Login or Register  to view this content.
    The total would be "2" because there are two unique "Customer Name" that have "Outcome" TRUE.
    I could convert the Outcome column to 1/0 instead of T/F if that makes this more possible by working with integers instead of string or bool values.

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,570

    Re: Count how many unique name are true

    Welcome to Excel Forum. For future reference one of the benefits of this forum is the ability to upload files (directions in FAQ)
    This solution applies a helper column which could be hidden for aesthetic purposes. The formula for column J, the helper column, is:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    A SUM function can then be used, in any cell, to show the number of customers that have an outcome of TRUE.
    Let me know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  3. #3
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Count how many unique name are true

    If I understand what you want to do...

    Data Range
    A
    B
    C
    D
    1
    Customer1
    TRUE
    2
    2
    Customer1
    TRUE
    ------
    ------
    3
    Customer1
    FALSE
    4
    Customer2
    FALSE
    5
    Customer3
    TRUE
    6
    Customer3
    FALSE


    This array formula** entered in D1:

    =SUM(IF(FREQUENCY(IF(B1:B6=TRUE,MATCH(A1:A6,A1:A6,0)),ROW(A1:A6)-ROW(A1)+1),1))

    ** array formulas need to be entered using the key
    combination of CTRL,SHIFT,ENTER (not just ENTER).
    Hold down both the CTRL key and the SHIFT key
    then hit ENTER.
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

+ 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. Create unique # of worksheets based on list count with unique names
    By Groovicles in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-24-2016, 09:51 AM
  2. [SOLVED] Unique Total Value Count per Unique Lookup Values
    By KnightVision in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-02-2014, 05:03 AM
  3. [SOLVED] Count unique entries based off unique criteria in another column
    By hambly in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 06-11-2014, 03:33 PM
  4. [SOLVED] Advanced Filter = Unique True
    By johnny_p in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-07-2014, 10:57 AM
  5. [SOLVED] How To Count Unique Values in COL A Subject for each unique value in COL B ??
    By amirtehrani in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-06-2012, 03:00 AM
  6. Replies: 0
    Last Post: 03-22-2012, 08:44 PM
  7. Replies: 17
    Last Post: 08-24-2009, 08:58 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