I'm probably missing something very obvious, but I have the following data:
ACCT 4
ACCT 2
CS 20
CS 10
ENG 20
ENG 10
ENG 30
What I want is to get the average of each department. So it should look like the following:
ACCT 3
CS 15
ENG 20
I have about 4000 rows of data and don't want to have to split the data into 40+ sheets. Thanks!