Count unique dates with criteria - Excel 365

[DK27]

Hi,

Hoping someoone can help with a formula I have been struggling to work out.

I have a dataset that contains all hours worked per week per technician. I have created a pivot table to sum the total hours worked. On a seperate tab I have a vlook up to pull the totals though into the format that our payroll system will ingest. The last piece is counting the number of unique dates per technician from the original data in the first tab. This will give me the number of days the technician has worked i.i. days paid. (coulmn F, tab 3)

Could someone please help develop a formula that can count the individual dates per technician.

Much appreciated.

I am trying to get xl2bb working but our IT are working on it, as it isn't working for me. Picture attached.

Cheers

 

[hagia_sofia]

Do you mean something like:

=SUM(--(ISNUMBER(UNIQUE(FILTER($C$2:$C$30,$A$2:$A$30=B2)))))

where $C$2:$C$30 stands for "Timesheet Work Date", $A$2:$A$30 stands for Username and B2 stands for Employee ID?

P. S. I am not sure what is the purpose of Pay Rate ID but you could always incorporate another condition...

 

[Cubist]

Adapt the last row of data. Try:

=IFERROR(ROWS(UNIQUE(FILTER('Data Dump'!$C$2:$C$30,'Data Dump'!$A$2:$A$30=B2))),0)

 

[DK27]

Do you mean something like:

=SUM(--(ISNUMBER(UNIQUE(FILTER($C$2:$C$30,$A$2:$A$30=B2)))))

where $C$2:$C$30 stands for "Timesheet Work Date", $A$2:$A$30 stands for Username and B2 stands for Employee ID?

P. S. I am not sure what is the purpose of Pay Rate ID but you could always incorporate another condition...

This worked perfectly. Thank you!!