So this is my first post on this forum, mostly because I have spent months lurking and pulling code from other posts. (That's how it should be done on a forum, right) But I have finally gotten to a problem I haven't been able to solve myself.
This is another unique frequency question also with two conditions. However the difference with my situation is that mine seems to combine two of the common problems, both of which I have solved independently, but have not been able to make work in conjunction.
I need to count unique entries in a list of numbers that fall between a given date range, with one criteria. I have mocked up a sample of my data to explain.
Last edited by magicbob007; 11-16-2011 at 01:23 PM.
Hello,
Assume users always be a valid numbers. If so try these Array Formulas, If users are not valid numbers will need to use MATCH.
I2,
=SUM(SIGN(FREQUENCY(IF(Table1[Criteria]="N",Table1[User]),Table1[User])))
I3,
=SUM(SIGN(FREQUENCY(IF(Table1[Date]>=K3,IF(Table1[Date]<=L3,Table1[User])),Table1[User])))
I6,
=SUM(SIGN(FREQUENCY(IF(Table1[Date]>=K3,IF(Table1[Date]<=L3,IF(Table1[Criteria]="N",Table1[User]))),Table1[User])))
HTH; Haseeb
If your problem is solved, please say so clearly, and mark your thread as Solved:
Forum Rules & How to Mark a thread as SOLVED
Oh that is elegant! Thanks for the quick reply!
=SUM(SIGN(FREQUENCY(IF(Table1[Criteria]="N",Table1[User]),Table1[User])))
This is beautiful...basically reduces it to a sumifs function! This would have saved me a week of searching. Thanks again.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks