Thanks, Norman !
Works great
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"N Harkawat" wrote in message
...
on cell c2 type
=SUMIF(A:A,A2,B:B)/COUNTIF(A:A,A2)
and copy it all the way down thru the extent of your range