Hi elf4278

Your problem is not a complicated one per se, the problem is the way
your data is ordered. If the data is in the form you say it is in I
would do the following;

Make a copy of the sheet you are working on. Then Copy Student,
Editor2 and Score(2) and paste this data at the base of the Student
column A, repeat this step for Editor(3) and score(3) pasting at the
base of your student column. Remove the unwanted columns – D through
to G. Sort the data by student, Col A.

Now you are in business. Your data should look like this

Student Editor Name Score
Student A John 20
Student A Jane 25
Student A Joe 22

etc.....

This format gives you flexibility and now you can do some analysis on
it.

Now create another table with a unique list of your Editors.

Use the following formula for Mean – changing your variables.

=SUMPRODUCT((B2:B7="John")*(C2:C7))/COUNTIF(B2:B7,"John")

For the Standard deviation paste this formula, change the variables
and press Ctrl – Shift – Enter This will create an array formula for
your standard deviation.

=STDEV(IF(B2:B7="John",C2:C7))

For both formulas I would reference the Unique Editor cells in the
formula so you are not typing their names at all.

Don’t hesitate to post if you need further assistance.

Take care

Marcus