+ Reply to Thread
Results 1 to 6 of 6

UDF for Counting Unique Text Within Date Range

  1. #1
    Registered User
    Join Date
    10-09-2012
    Location
    Toronto
    MS-Off Ver
    Excel 2010
    Posts
    11

    UDF for Counting Unique Text Within Date Range

    Hi all, I have this wonderful User Defined Function below that counts unique text within a range. The problem is you cant specify a date range as as in COUNTIFS functions. Can this code be modified to specify date ranges? For example
    Please Login or Register  to view this content.
    Here's the code:

    Please Login or Register  to view this content.

  2. #2
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,376

    Re: UDF for Counting Unique Text Within Date Range

    Hi Robert41
    maybe so
    Please Login or Register  to view this content.
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    10-09-2012
    Location
    Toronto
    MS-Off Ver
    Excel 2010
    Posts
    11

    Re: UDF for Counting Unique Text Within Date Range

    Thanks nilem for your reply. I think this will work but I may be missing something in my worksheet that I have here. Can you check it for me please? Thanks again CountUniqueDate.xlsm

  4. #4
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,376

    Re: UDF for Counting Unique Text Within Date Range

    see attachment
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    10-09-2012
    Location
    Toronto
    MS-Off Ver
    Excel 2010
    Posts
    11

    Re: UDF for Counting Unique Text Within Date Range

    Quote Originally Posted by nilem View Post
    see attachment
    Hi nilem, I now see what your formula does and its very close to what I need. Is there any way to count the text in column A1:A9 instead of the dates in column B? So it would be CountUniqueDate(A1:A9,"01/10/2012","31/10/2012") to count unique values in column A that are >= 01-Oct-2012 And <= 31-Oct-2012 in column B. That would be perfect. Regards

  6. #6
    Registered User
    Join Date
    10-09-2012
    Location
    Toronto
    MS-Off Ver
    Excel 2010
    Posts
    11

    Re: UDF for Counting Unique Text Within Date Range

    Ok nilem, I found the solution on another forum which I will post below to help others here with this problem. Special thanks to Vladimir Zakharov for this solution

    User Define Function to Count unique values with separate ranges for data and for conditional values:

    Please Login or Register  to view this content.

+ 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