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...
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!
