+ Reply to Thread
Results 1 to 5 of 5

Count Unique Values of defined cell between Two Dates

  1. #1
    Registered User
    Join Date
    10-15-2012
    Location
    Los Angeles, CA
    MS-Off Ver
    Excel 2010
    Posts
    94

    Cool Count Unique Values of defined cell between Two Dates

    I have a group of employees who work different divisions and work is not done everyday. I want to count the unique values of a division (only once) per day that the division shows up. Within a week, workers in a division might work 3 days and not other days. I've tried a few array formulas but they count unique within a range and I need the unique value to be based on the selected cell.

    Please see attached

    Thanks for the help.

    Unique Values In Between Dates.xlsx

  2. #2
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: Count Unique Values of defined cell between Two Dates

    Hi,

    In I2, enter this array formula (confirm with CTRL+SHIFT+ENTER, not just ENTER) and copy down as required:

    =SUMPRODUCT(--(FREQUENCY(IF(($C$2:$C$25=H2)*($A$2:$A$25>=F2)*($A$2:$A$25<=G2),$A$2:$A$25),IF(($C$2:$C$25=H2)*($A$2:$A$25>=F2)*($A$2:$A$25<=G2),$A$2:$A$25))>0))

    Regards
    Click * below if this answer helped

    Advanced Excel Techniques: http://excelxor.com/

  3. #3
    Registered User
    Join Date
    10-15-2012
    Location
    Los Angeles, CA
    MS-Off Ver
    Excel 2010
    Posts
    94

    Re: Count Unique Values of defined cell between Two Dates

    You are on top of things sir. Much appreciated. I'd click the * more but it won't let me Take care.

  4. #4
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: Count Unique Values of defined cell between Two Dates

    You're welcome.

  5. #5
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Count Unique Values of defined cell between Two Dates

    Why not use a Pivot Table to summarize your data?
    Attached Files Attached Files
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

+ 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. Need a count of unique values in col. with multiple values in a cell.
    By DrewS in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-22-2013, 01:03 PM
  2. [SOLVED] Count Multiple Unique Values in One Cell
    By excelheaven in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-06-2012, 04:16 PM
  3. Count unique values between two dates in two columns
    By hnantz in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-09-2012, 05:57 PM
  4. Replies: 11
    Last Post: 11-05-2011, 12:34 PM
  5. total count of non-blank cell(s) and unique values
    By esanchezz in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 06-09-2010, 01:53 PM

Tags for this Thread

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