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.

Hi Robert41
maybe so

Please Login or Register  to view this content.

Please Login or Register  to view this content.

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

see attachment

Originally Posted by nilem

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

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.