Forum Discussion
Solved
How to calculate how many days a person have worked from a list of transactions
Hi all, I need to know how many dayes a person have been present at work by using some data from a list: On the column A I have a list of transactions (sold an apple, sold an orange, sold something...
Let's say your data are in A2:C800.
With a name such as Tom in E2, enter the following formula in F2:
=IF(COUNTIF($B$2:$B$800,E2)=0,0,COUNTA(UNIQUE(FILTER($C$2:$C$800,$B$2:$B$800=E2))))
This can be filled down.
(It returns 2 for Jack in your example: Jack worked on 01.02 and 03.02)
Let's say your data are in A2:C800.
With a name such as Tom in E2, enter the following formula in F2:
=IF(COUNTIF($B$2:$B$800,E2)=0,0,COUNTA(UNIQUE(FILTER($C$2:$C$800,$B$2:$B$800=E2))))
This can be filled down.
(It returns 2 for Jack in your example: Jack worked on 01.02 and 03.02)
