Hi all,
I have tried to analysis the popularity of History lession, amonst students.
but kinda stuck on first hurdle...
I have tied using MATCH and INDEX in the array formula but cannot combine it with the IF...
i need to show 0 if the student has not work together in this group, or 1 if they have for any of the 10 days.
Thanks in advance