DataSubtotals, choose Use function Average

--
Kind regards,

Niek Otten

"chapm4" wrote in
message ...

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