Challenge #135: Locker Problem

[knagano]

I misunderstood the question.
I thought that each student open/close only 5 lockers, finally I could get the answer...

My solution is as follows;

Spoiler

 

 

[lwolfie]

If only every iterative macro made sense like this one.

[yongjae]

My Solution

[Carolyn]

That was fun! And I did it without an Iterative macro

Spoiler

I used MOD(LockerID, Student ID) and filtered for when the MOD=0 which tells me that it's a locker that the Student would change its state. 

I then counted each time a student touched the locker. If it was even, the end state would be Closed. If it was odd, the end state would be Open