<div>
do you know how to create a pivot table? &nbsp;That should be able to give you a breakdown of all employees and the days they worked.<br />
<br />
How do you need to use this days-worked count? (in code, in formula, other)
</div>


do you know how to create a pivot table?  That should be able to give you a breakdown of all employees and the days they worked.

How do you need to use this days-worked count? (in code, in formula, other)

<div>
Thanks a lot.<br />
I really made my task easy.
</div>


Thanks a lot.
I really made my task easy.

<div>
<div class="content wysiwyg-content">
hi,<br />
<br />
I have 3 columns , column A with date and coulmn B with name of employee and column C with work type.<br />
I want to know the number of days workded by each employee.<br />
1-Feb &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;a<br />
1-Feb &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;a<br />
2-Feb &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;a<br />
2-Feb &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;a<br />
2-Feb &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;a<br />
2-Feb &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;a<br />
2-Feb &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;a<br />
2-Feb &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;a<br />
4-Feb &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;a<br />
4-Feb &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;a<br />
4-Feb &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;a<br />
4-Feb &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;a<br />
1-Feb &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;B<br />
1-Feb &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;B<br />
1-Feb &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;B<br />
2-Feb &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;B<br />
2-Feb &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;B<br />
2-Feb &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;B<br />
2-Feb &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;B<br />
2-Feb &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;B<br />
2-Feb &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;B<br />
3-Feb &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;B<br />
3-Feb &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;B<br />
3-Feb &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;B<br />
3-Feb &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;B<br />
3-Feb &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;B<br />
<br />
<br />
here a should give answer 3 as he has worked for 3 days (1st, 2nd and 4th of Feb)<br />
similarly B should give answer 3 as he has worked for 3 dys.(1st, 2nd and 3rd of Feb)<br />
<br />
<br />
&nbsp;
</div>
</div>


hi,

I have 3 columns , column A with date and coulmn B with name of employee and column C with work type.
I want to know the number of days workded by each employee.
1-Feb	a
1-Feb	a
2-Feb	a
2-Feb	a
2-Feb	a
2-Feb	a
2-Feb	a
2-Feb	a
4-Feb	a
4-Feb	a
4-Feb	a
4-Feb	a
1-Feb	B
1-Feb	B
1-Feb	B
2-Feb	B
2-Feb	B
2-Feb	B
2-Feb	B
2-Feb	B
2-Feb	B
3-Feb	B
3-Feb	B
3-Feb	B
3-Feb	B
3-Feb	B


here a should give answer 3 as he has worked for 3 days (1st, 2nd and 4th of Feb)
similarly B should give answer 3 as he has worked for 3 dys.(1st, 2nd and 3rd of Feb)


 

Unique count

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.