Hello, any help is appreciated. Basically, I have a list of students that have to take two different tests (a reading and a math) at 5 specific times per year. I have to set up a spreadsheet that accomplishes two things:
-Calculate percent change for each student between each administration of the tests (which I have done), AND
-Calculate percent change for each student between the first and last administration of the tests
This would be easy, except not all students will take the tests every time. Many students transfer in and out at different times throughout the year, so they might only have scores for the last 3 columns.
How would I make excel look for the first and last cells that have data in columns F-J and calculate percent change from the first score to the last in column D. Same thing for columns T-W and calculate percent change in column E? MIN MAX isn't ideal because some students scores are erratic, not steady up or down.
I can't attach a file, otherwise I would attach what I am working with. Thanks for any advice.
-Calculate percent change for each student between each administration of the tests (which I have done), AND
-Calculate percent change for each student between the first and last administration of the tests
This would be easy, except not all students will take the tests every time. Many students transfer in and out at different times throughout the year, so they might only have scores for the last 3 columns.
How would I make excel look for the first and last cells that have data in columns F-J and calculate percent change from the first score to the last in column D. Same thing for columns T-W and calculate percent change in column E? MIN MAX isn't ideal because some students scores are erratic, not steady up or down.
I can't attach a file, otherwise I would attach what I am working with. Thanks for any advice.