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
<tbody>
</tbody><colgroup><col><col></colgroup>
And the result I want is:
<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
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