+ Reply to Thread
Results 1 to 3 of 3

Count unique values based multiple criterias

  1. #1
    Forum Contributor
    Join Date
    12-05-2008
    Location
    Kiruna
    Posts
    163

    Count unique values based multiple criterias

    Hi
    i have trouble to get a formula to count unique values based on multiple criteria

    I get it this formula to work
    Please Login or Register  to view this content.
    If the data looks like this:

    1022-26, 2014-01-01
    1022-26, 2014-01-01
    1022-26, 2014-01-02
    1022-26, 2014-01-02


    It will count the unique value correct to 2.

    But how do i add another criteria (for FM) ?

    FM, 1022-26, 2014-01-01
    FM, 1022-26, 2014-01-01
    FM, 1022-26, 2014-01-01
    FM, 1022-26, 2014-01-02
    FM, 1022-26, 2014-01-02

    This should also results in 2.

    sample workbook: test.xlsx

    Best regards Petter
    Last edited by Petter120; 11-03-2014 at 03:07 AM. Reason: Changed the formula language to English.

  2. #2
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Count unique values based multiple criterias

    How about this array?:

    =SUM(IF(FREQUENCY(IF($G$2:$G$1000<>"",IF(INDEX($C$2:$C$1000&$A$2:$A$1000, 0)=R2&Q2,MATCH("~"&$G$2:$G$1000&"",$G$2:$G$1000&"",))),ROW($G$2:$G$1000)-ROW($G$2)+1),1))
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

  3. #3
    Forum Contributor
    Join Date
    12-05-2008
    Location
    Kiruna
    Posts
    163

    Re: Count unique values based multiple criterias

    Thank you it works fine

+ 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. [SOLVED] count unique values across multiple sheets based on date
    By roninn75 in forum Excel General
    Replies: 8
    Last Post: 02-25-2014, 05:20 PM
  2. [SOLVED] How to count unique values using multiple criterias
    By Charmymay in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-07-2013, 11:27 AM
  3. [SOLVED] how to count unique values in excel based on multiple criteria
    By IDBUGM in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-15-2006, 12:10 PM

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