Forum Discussion
Solved
Count User Logins
Hi there, I have been given a spreadsheet which contains a table of data. One of the columns is for dates, the other contains student IDs. I have been asked to count the number of student's that have logged in to the site between two different dates, but to exclude duplicates i.e. when a student has logged in more than once between these dates do not count more than once. I am really struggling to find a formula that will solve this for me. Any help would be much appreciated.
Do you have Microsoft 365 or Office 2021? If so, it's very easy:
=COUNTA(UNIQUE(FILTER(ID_range,(date_range>=start_date)*(date_range<=end_date))))
Do you have Microsoft 365 or Office 2021? If so, it's very easy:
=COUNTA(UNIQUE(FILTER(ID_range,(date_range>=start_date)*(date_range<=end_date))))HansVogelaar That worked, thank you!
