Results 1 to 18 of 18

Count amount of unique values with multiple conditions

Threaded View

  1. #1
    Registered User
    Join Date
    04-20-2015
    Location
    Amsterdam, Netherlands
    MS-Off Ver
    2010
    Posts
    16

    Count amount of unique values with multiple conditions

    Hi,

    I can't succeed to count the amount of unique values with multiple criteria. The columns are employee#, week, year, date and invoicing method.
    Employee#: the employee# occurs so now and then double within a date. Employee# should not be counted if there is more than one unique number on unique date.
    Week: The cutoff date is variable and is set on the first of may for now (Week 18). The search has to be of last month (4 weeks) on date or in the week column, so < week 18 and > week 13
    Year: Year of cutoff date, so 2015.
    Date: Each row has a date. As stated above there are dates with duplicate employee#'s.
    Invoicing method: Should only be counted when "YES"

    There has been already a similar post about this issue but I can't seem to comprehend it and apply it on my sheet.

    Anyone fancy helping out?
    Please find attached an Example.xlsx.


    Looking forward to the responses.
    Edit: Right answer is 6.
    The rows that apply to the criteria are:
    5 (regular)
    6 (or 7 since it is a duplicate with same date)
    9 ( Same employ# but seperate date)
    10 (Same employ# but seperate date)
    12 (Different employ# same date)
    13 (Different employ# same date)
    Last edited by Melon6; 05-21-2015 at 03:34 AM. Reason: Wrong count

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Count only unique values with two conditions
    By Melon6 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-01-2015, 05:24 AM
  2. Count unique values with multiple conditions
    By liybpg in forum Excel General
    Replies: 6
    Last Post: 03-18-2015, 05:43 AM
  3. Count Unique Values With Multiple Conditions, Array Method
    By 5150 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-28-2014, 04:37 PM
  4. [SOLVED] count the number of unique values given certain conditions
    By eh308701 in forum Excel General
    Replies: 8
    Last Post: 05-31-2012, 11:48 PM
  5. Count unique logs with multiple conditions of multiple sheets
    By Robert Bob in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 10-12-2007, 12:49 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