Oct 28 2022 12:40 AM
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
Oct 28 2022 04:32 AM
=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.