▲ 0 r/googlesheets
I need to take avgs of grades for students with matching IDs
Part 1: I need help creating a formula that takes the average of every science grade a student has earned. I've never had to use the =exact or =search functions before, so I tried fiddling around with them, but can't wrap my head around them.
The logic that I think works would be using an =if( to find exact matches, then taking the average.
Part 2: I want to delete the rows of duplicate IDs after the averages have been calculated.
I have to do this every year, so getting any help would be greatly appreciated!
u/NatTwenty20 — 3 days ago