SOLVED

Count User Logins

New Contributor

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.

2 Replies
best response confirmed by Sergei Baklan (MVP)
Solution

@jadeweller 

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))))

@Hans Vogelaar That worked, thank you!