Filter duplicates per day

Occasional Visitor

Hi all, thank you for opening my query. 

So, I have an excel spreadsheet, carrying data inside it of a headcount. What I need, is a unique headcount per day of how many people are coming into the workplace. The issue is, people can scan in and out multiple times a day, and thus have been registered in the system multiple times a day. I need to filter out the duplicates for each day of the month, without eliminating all of the duplicates in the spreadsheet (as this will only show one unique name per month, and it can't be analysed if someone has come in more than once that month). 

 

Please do not hesitate to ask any questions. 

 

Regards, Proton

1 Reply

@professor_proton 

=COUNT(UNIQUE(FILTER($A$2:$B$23,$A$2:$A$23=E2)))

If you have Office365 or Excel 2021 or Excel online you can try this formula.

people at the workplace.JPG