Applying calculated values from a pivot table to individual records

[mcannally]

I have 2 columns of data (see example below):

A 10
B 5
A 20
A 30
B 15
C 10

I need a 3rd column which displays the average of each group for each record in that group, to get the following 3rd column results:

20 (which is the average of A)
10 (which is the average of B)
20
20
10
10 (which is the average of C)

Pivot table to calculate the averages? What then? Thanks.

 

[Weazel]

maybe something like...

=AVERAGEIF($A$2:$A$7,A2,$B$2:$B$7)

assuming your data starts in a2, copied down

 

[mcannally]

Thanks. But what if the # rows is dynamic?