SOLVED
Challenge #135: Locker Problem
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
knagano
7 - Meteor
08-18-2024
06:37 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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;
lwolfie
11 - Bolide
08-23-2024
12:06 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
yongjae
7 - Meteor
08-27-2024
07:33 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Carolyn
12 - Quasar
09-05-2024
02:43 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
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
Yogesh1795
8 - Asteroid
10-24-2024
06:40 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
cmoussa
8 - Asteroid
11-24-2024
06:17 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Layton_Mosley
7 - Meteor
3 weeks ago
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
DylanBell
8 - Asteroid
2 weeks ago
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- « Previous
- Next »