Avg automatically

[Frank]

Is there any way to perform the averages below (last 2 row) using some
formula or macro in Excel? What I have is a number of occurrences with
the same number (top 10 rows), followed by some value. I want a unique
row per a column 1 value with the average of all those after it. I can
do this manually but really want to have this do this automatically once
I toss in some numbers.

Thanks,
Frank


1 53
1 60
1 60
1 60
1 60
2 60
2 60
2 60
2 60
2 58




1 58.6
2 59.6

 

[Lance]

Try
=SUMIF($A$1:$A$10,A15,$B$1:$B$10)/COUNTIF($A$1:$A$10,A15)