Hello,
I am trying to count the days worked for any given employee during a time period.
The only catch is that multiple days can show up for the same employee and this is where I am stuck.
Is there a way to only count the date once so it adds up to the correct number of work days?
I have an example attached.
In H2, enter =SUM(IF(FREQUENCY(IF($A$2:$A$36=G2,$B$2:$B$36),IF($A$2:$A$36=G2,$B$2:$B$36))>0,1)) with Ctrl + Shift + Enter keys together.
In H2, enter =SUM(IF(FREQUENCY(IF($A$2:$A$36=G2,$B$2:$B$36),IF($A$2:$A$36=G2,$B$2:$B$36))>0,1)) with Ctrl + Shift + Enter keys together.
Thanks! Worked like a charm!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks