How would I count unique dates associated with another specific value on a worksheet?
For instance, Lets say I want to count each day a particular person makes a sale.
Example:
Sales Person Sale ID Sales Date
Don 100 1/6/2014
Don 140 1/7/2014
Don 160 1/8/2014
Jack 101 1/6/2014
Jack 102 1/6/2014
Mike 90 1/5/2014
Mike 103 1/6/2014
So on another worksheet, I'd have:
Sales Person Days with Sale
Don 3
Jack 1
Mike 2
The Formula would go into the "Days with Sale" Column.
Any ideas?
Let's say that your data is in Data worksheet with names in column A and dates in column C then in your summary sheet with name in A2 use this "array formula" in B2
=SUM(IF(FREQUENCY(IF(Data!A$2:A$1000=A2,Data!C$2:C$1000),Data!C$2:C$1000),1))
confirmed with CTRL+SHIFT+ENTER and copied down
Audere est facere
Have you try Pivot Table?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks