Forum Discussion
Solved
Remove Duplicates in Col A & group them by date
Hello I have excel sheet with the users logged in to a certain system on daily basis. each day the user might login to the system more than one time. I want to remove the duplicated user from eac...
ziying35
Impactful Individual
Impactful IndividualCan you simulate a result table and upload a file?
Hello
the output I'm expecting after removing the duplicated users and group by date is:
| Date | Count of Unique Users per day |
| 5/7/2020 | 20 |
| 5/6/2020 | 11 |
| 5/5/2020 | 17 |