+ Reply to Thread
Results 1 to 2 of 2

How to Get Unique count with Multiple Condition.

  1. #1
    Registered User
    Join Date
    07-01-2014
    Location
    New Delhi , India
    MS-Off Ver
    2007
    Posts
    51

    How to Get Unique count with Multiple Condition.

    Hi can any one help me in Unique count with multiple condition.

    For Ex :

    Date Time LDAP Week worker_ID Name Day
    15-Dec-14 4:21:51 PM karangu 51 17103 Karan Gupta Mon
    16-Dec-14 3:35:30 PM karangu 51 17103 Karan Gupta Tue
    16-Dec-14 4:17:14 PM karangu 51 17103 Karan Gupta Tue
    17-Dec-14 4:26:27 PM karangu 51 17103 Karan Gupta Wed
    18-Dec-14 4:20:42 PM karangu 51 17103 Karan Gupta Thu
    19-Dec-14 4:20:06 PM karangu 51 17103 Karan Gupta Fri

    Condition : Worker_ID=17103
    Week=51
    Unique count (Day)
    Ans: 5 Days


    I Tried =SUMPRODUCT(1/countifs(Q:Q,17013,P:P,51,S2:S360,S2:S360))
    =Sum(if( (Q:Q=17013)*(P:P=51),Sumproduct(1/Countif(S2:S360,S2:S360)),0)

    But it not working , can any one help please

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,480

    Re: How to Get Unique count with Multiple Condition.

    wheres the sample workbook?

+ 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] how to count unique entries with multiple condition
    By Michael in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 10:05 AM
  2. [SOLVED] how to count unique entries with multiple condition
    By Bob Phillips in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 09-06-2005, 06:05 AM
  3. how to count unique entries with multiple condition
    By Bob Phillips in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 09-06-2005, 04:05 AM
  4. [SOLVED] how to count unique entries with multiple condition
    By Michael in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 AM
  5. [SOLVED] how to count unique entries with multiple condition
    By Michael in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 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