Column A has an Employee Name
Column B has a Date
An employee name can repeat on the same date
I want to know by month the sum of the count of the number of unique names each day.
John Doe 4/2/2019
John Doe 4/2/2019
Jack Smith 4/2/2019
John Doe 5/1/2019
Jack Smith 5/19/2019
Jack Smith 5/19/2019
Jack Smith 5/19/2019
Jack Smith 5/19/2019
Jack Smith 5/30/2019
Desired Result
April=2
May=3
Column B has a Date
An employee name can repeat on the same date
I want to know by month the sum of the count of the number of unique names each day.
John Doe 4/2/2019
John Doe 4/2/2019
Jack Smith 4/2/2019
John Doe 5/1/2019
Jack Smith 5/19/2019
Jack Smith 5/19/2019
Jack Smith 5/19/2019
Jack Smith 5/19/2019
Jack Smith 5/30/2019
Desired Result
April=2
May=3