Hello! I posted here once before and you guys were so incredibly helpful- quite literally saved me 100 hours of work.
So for my work I have this excel spreadsheet with every teacher in the state of Minnesota. It's already been sorted down to those that teach subjects relevant to what my organization does- and I spent about a week sorting all of the high school teachers my region. I'm now trying to do the same thing with all of the Middle School teachers, but it's 60,000 entries and that's just an insane number of teachers to sort manually.
The nuts and bolts: I have a tab with every Middle School teacher we need, and six tabs for each region of the state. Each teacher has the district they teach in, and I have a list that shows which region each district is. So what I've been doing is sorting by district (so that it's at least in groups), and then selecting all of the teachers in a given district, checking the list, and putting them in the corresponding region tab. It takes less time then doing it one by one, but surely there's a quicker way to do this. Each region has about 50 districts, and there's a total of 336 districts in Minnesota. So it's not like I can just quickly sort them by region, there's far too many.
Is there some sort of command or formula that can speed up this process?
Thanks again for your help last time, hopefully you can help me again.
Bookmarks