find the average of B correspond to their A

[corrilow]

Hi all
I need to find the average B values corresponding to the same A and input it in C. Something like what is shown below:



A B C
1 1 (1+2+3)/3
1 2
1 3
2 5 (5+1+2)/3
2 1
2 2
3 6 6
4 7 (7+6+9)/3
4 6
4 9


However, I have a long list of numbers (A rangers sequentially from 1 to 25000) So I am looking for a function that will auto go down the list to compute the C values.


Thanks =)

[Rabk]

Will the values in 'A' always be in increasig order like they are in your example? Or will they ever be mixed up like this?:

A B
1 1
4 9
1 3
2 5
4 6
1 2
2 1
2 2
3 6
4 7

[corrilow]

hi!

A will always be in increasing order. =)