+ Reply to Thread
Results 1 to 2 of 2

Count Unique Names in list w/ Additional Criteria?

  1. #1
    Nodak
    Guest

    Count Unique Names in list w/ Additional Criteria?

    I have been able to use the formula below to count the "unique" company names
    in list, but also wanted to use additional criteria such as Unique company
    names where state = TX (separate column).... what would the syntax be? is
    this possible?.

    =SUMPRODUCT(1/(COUNTIF(Company_Name,Company_Name)+(Company_Name="")))



  2. #2
    Jason Morin
    Guest

    Re: Count Unique Names in list w/ Additional Criteria?

    You could use the FREQUENCY method to count unique items
    based on 1 or more criteria. George Simms posted a simple
    example a long time ago:

    http://tinyurl.com/3pkqr

    HTH
    Jason
    Atlanta, GA

    >-----Original Message-----
    >I have been able to use the formula below to count

    the "unique" company names
    >in list, but also wanted to use additional criteria such

    as Unique company
    >names where state = TX (separate column).... what would

    the syntax be? is
    >this possible?.
    >
    >=SUMPRODUCT(1/(COUNTIF(Company_Name,Company_Name)+

    (Company_Name="")))
    >
    >
    >.
    >


+ 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