The attached spreadsheet has a list of students. I need to find the easiest way to create a list based on certain school codes (last column). For example only look at the data for students from school codes 52661, 51050, 52881, 53765 and 51590. Based on that set of data, calculate the GPAs, test scores, etc. What would be the easiest way? I have tons of worksheets to do this with. I tried pivot table method but is there a quicker way?
Please note that on 14th December 2023 users will experience an expected outage whilst we make upgrades to our network. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.