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
