sure this is easy for you smart ones.......

Column A has identifiers for locations 1-11
Column B has test scores
I want average test scores for each of the locations


1 6.8
9 12.9
1 12.9
2 11.3
2 12.9
2 7.7
2 7.7
9 12.9
1 10.8
1 12.9
11 12.9

Can anyone help?


--
chapm4
------------------------------------------------------------------------
chapm4's Profile: http://www.excelforum.com/member.php...o&userid=16259
View this thread: http://www.excelforum.com/showthread...hreadid=500353