Find number of days worked with formula

[asad]

Hello All,

I am trying to calculate the number of days each person has worked. There may be multiple entries per person for each date and some people may have only one or two entries for each date.
The data is something like this

Date	Employee
1/01/2016	Suheyla Alper
1/01/2016	Maria Ruggiero
1/01/2016	Suheyla Alper
1/01/2016	Suheyla Alper
1/01/2016	Matchew Liu
1/01/2016	Lauren Hammond
1/01/2016	Garyfalia Derzotis
1/01/2016	Chris Szczabrowski
2/01/2016	Suheyla Alper
2/01/2016	Maria Ruggiero
2/01/2016	Suheyla Alper
2/01/2016	Suheyla Alper
2/01/2016	Matchew Liu
2/01/2016	Lauren Hammond
2/01/2016	Garyfalia Derzotis
2/01/2016	Chris Szczabrowski
3/01/2016	Suheyla Alper
3/01/2016	Maria Ruggiero
3/01/2016	Suheyla Alper
3/01/2016	Suheyla Alper
3/01/2016	Matchew Liu
3/01/2016	Lauren Hammond
3/01/2016	Garyfalia Derzotis
3/01/2016	Chris Szczabrowski
4/01/2016	Suheyla Alper
4/01/2016	Suheyla Alper
4/01/2016	Suheyla Alper
4/01/2016	Matchew Liu
4/01/2016	Lauren Hammond
4/01/2016	Garyfalia Derzotis
4/01/2016	Chris Szczabrowski

<tbody>
</tbody><colgroup><col><col></colgroup>

And the result I want is:

Employee	No of Days Worked
Suheyla Alper	4
Maria Ruggiero	3

<tbody>
</tbody><colgroup><col><col></colgroup>

How can I do this with a formula. The data table runs into hundreds of thousand of rows. I tried pivot table but it gives me a count of each entry and this is wrong answer.

Thanks
Asad

 

[cchavez24]

I would copy all of the data to another sheet as to keep an original copy. Then using Auto-Filter remove all of the duplicates based on the name and date so that each employee can only be listed once per date. Then use the pivot table. It will work and save you a lot of headaches.

If you need further help with this, just comet and I will help.

 

[asad]

Thanks for the solution. It worked. I will use this for the time being and wait for a solution that does not require copy pasting of 15+ columns and 200,000+ rows.
Thanks again.