I can't figure out the count. Thank you, if you can help.

[bgurtz]

I have cells A1 with dates such as 1/2/18
I have cell B1 with names (some are duplicate)
I am trying to figure out away to count how many (unique) names worked on per day of the month.
I can not figure out how to do this. I have tried using the .. =SUMPRODUCT(1/COUNTIF(A1:A22,A1:A22))
I can get the unique value for a people, but i can not get it to do the dates,

Any help would be great. Thank you.

1/5/2018	Mike	............
1/5/2018	Mike	Example:
1/5/2018	Chris	1/5/2018 .. 4 people worlked
1/5/2018	Frank
1/5/2018	Chase	1/7/2018 .. 2 people worked
1/7/2018	Kian
1/7/2018	Corey
1/7/2018	Corey
1/10/2018	Frank
1/10/2018	Mark
1/14/2018	Frank
1/22/2018	Knox
1/22/2018	Kian
1/22/2018	Mike
1/22/2018	Mike

<tbody>
</tbody>

 

[AhoyNC]

Try:
This is an array formula and must be entered with CTRL-SHIFT-ENTER.
Drag formula down as needed.

Excel Workbook
	A	B	C	D
1	Date	Name	Date	Count
2	1/5/2018	Mike	1/5/2018	4
3	1/5/2018	Mike	1/7/2018	2
4	1/5/2018	Chris	1/10/2018	2
5	1/5/2018	Frank	1/14/2018	1
6	1/5/2018	Chase	1/22/2018	3
7	1/7/2018	Kian
8	1/7/2018	Corey
9	1/7/2018	Corey
10	1/10/2018	Frank
11	1/10/2018	Mark
12	1/14/2018	Frank
13	1/22/2018	Knox
14	1/22/2018	Kian
15	1/22/2018	Mike
16	1/22/2018	Mike
Sheet

 

[XlsXprt]

Try this!

The formula I put in cell E4 is

=SUMPRODUCT((($A$1:$A$15=D2))/COUNTIFS($A$1:$A$15,$A$1:$A$15&"",$B$1:$B$15,$B$1:$B$15&""))

 

[bgurtz]

Thank you so much

 

[bgurtz]

I thought I had this, but i must be doing something wrong, I can not get it to work correct. I have been reading and trying to figure out what I have done wrong with the answers I have been given, but I must be doing it wrong. can anyone upload a sample sheet so i can see what i am doing wrong?

 

[bgurtz]

I just get a 0 (zero) or a #REF !

 

[AhoyNC]

The formula in post #2 is an array formula and must be entered with CTRL-SHIFT-ENTER.

If you just hit the enter key.
Press F2 key for edit.
Then CTRL-SHIFT-ENTER.

Note you can just copy my example into Excel.