Hi can any one help me in Unique count with multiple condition.
For Ex :
Date Time LDAP Week worker_ID Name Day
15-Dec-14 4:21:51 PM karangu 51 17103 Karan Gupta Mon
16-Dec-14 3:35:30 PM karangu 51 17103 Karan Gupta Tue
16-Dec-14 4:17:14 PM karangu 51 17103 Karan Gupta Tue
17-Dec-14 4:26:27 PM karangu 51 17103 Karan Gupta Wed
18-Dec-14 4:20:42 PM karangu 51 17103 Karan Gupta Thu
19-Dec-14 4:20:06 PM karangu 51 17103 Karan Gupta Fri
Condition : Worker_ID=17103
Week=51
Unique count (Day)
Ans: 5 Days
I Tried =SUMPRODUCT(1/countifs(Q:Q,17013,P:P,51,S2:S360,S2:S360))
=Sum(if( (Q:Q=17013)*(P:P=51),Sumproduct(1/Countif(S2:S360,S2:S360)),0)
But it not working , can any one help please
Bookmarks