# Find number of days worked with formula

##### Well-known Member
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

### Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.

#### cchavez24

##### New Member
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.

##### Well-known Member
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.

Replies
3
Views
727
Replies
1
Views
369
Replies
3
Views
288
Replies
4
Views
285
Replies
3
Views
250

1,191,708
Messages
5,988,232
Members
440,139
Latest member
ngaicuong2017

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back