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
Thank you so much!
You are very welcome
Edit your original post and remove the link, now that you have real names of real people in that file. You can edit it by clicking on the three dots in the top right corner of the post.
- thanks! i'm facepalming lol
The FILTER function is very useful. You might appreciate this YouTube video, which is where I first learned of the function. https://www.youtube.com/watch?v=9I9DtFOVPIg