Forum Discussion
Filter duplicates per day
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 wo...
=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.