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!