Count Number of Unique Dates For Employee Name

Without VBA, we need to count the number of dates on which an employee completed at least one task. In other words, in the case where the employee completed more than one task on a single date, it only counts as one date for that employee. So we need the number of dates not the number of tasks.

We don’t need to know how many times a name appears rather how many unique dates contain that unique name.

The workbook has employee names in column ‘A’ and dates in column ‘B’. The problem we have is that the same date can occur many times in column ‘B’ and an employee name can re-occur several times on the same date.

A very small sample from seven thousand rows is below;
Row A B C
302 Bob 7/20/2012
303 Dan 7/20/2012
304 Bob 7/20/2012
305 Dan 7/20/2012
306 Bob 8/3/2012
307 Cindy 8/3/2012

If the formula works correctly, in the above sample, Bob’s results would be two, while Dan would be one.

Kind Thanks,
Eddie

Array confirmed with Shift Ctrl Enter

=SUM(SIGN(FREQUENCY(IF($A$2:$A$10="Bob",$B$2:$B$10),IF($A$2:$A$10="Bob",$B$2:$B$10))))

Replace "Bob" with an appropriate cell reference and expand the ranges to suit your real data.