+ Reply to Thread
Results 1 to 4 of 4

Counting unique criteria?

  1. #1
    Registered User
    Join Date
    11-06-2012
    Location
    NYC
    MS-Off Ver
    Excel 2007
    Posts
    16

    Counting unique criteria?

    I have a problem where I need to count unique criteria. For example:


    Name --Yellow---Blue---Green--
    Bob ------y--------------------
    Steve --------------------y----
    Bob ----------------------y----
    John -------------y------------
    Bob ------y--------------------
    James-----y-------------------

    I need to count the yellows, blues and greens, but I can't count the duplicate names per color.

    So Yellow would be 2, Green 2, and Blue 1.

    If this could somehow be done in a pivot tables I would like to know, but I've tried some counting solutions for pivot tables and they haven't worked when I need to filter the names by color. (Yellow would be 1.5 in the formulas I use)

    I'm not great with macros, but I'll figure it out if someone can provide a little help.
    Last edited by theThirdMan; 11-06-2012 at 05:53 PM.

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Counting unique criteria?

    Post an Excel file without confidentional information.

    I think it can be done by pivot table.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Registered User
    Join Date
    11-06-2012
    Location
    NYC
    MS-Off Ver
    Excel 2007
    Posts
    16

    Re: Counting unique criteria?

    I created a quick example similar to the format I need to use.

    In the pivot table you'll notice it's counting the account numbers based on the filtering criteria (Checking). I just want the employees visible counted (Each person who opened a checking account for someone, regardless of how many times). So it should count 4 when filtered by Checking.

    Thanks for any help!
    Attached Files Attached Files

  4. #4
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Counting unique criteria?

    Maybe like this?
    Attached Files Attached Files

+ 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