Forum Discussion
Solved
moving data to list based on adjacent cells
Hello, sorry if this has been answered already--I feel like I used to know this but I've forgotten. I am a teacher, and I'm trying to help my school streamline our dismissal process. We have a bus ma...
I've entered the following formula in your cell F2 and copied it to H2 and L2,
=FILTER($A$2:$B$13,$C$2:$C$13=F1,"None")
The result is this
Go check it out
Sorry to bother--how can I expand the length of the output lists? I'm working with the actual data now and I have busses with a lot more kids than the sample sheet. Thanks in advance!