Discussion on:
Message 3 of 3
0
Votes
Another way...
You could simply highlight the range $A$1:$C$13, then Insert a pivot table (Alt+N, V, T, Enter), drag "Region" to Row Labels, "Sold" to Values, click on "Value Field Settings", select "average", and - voila! Or, if you prefer, "Bob's your uncle".
Posted by ms344
Updated - 1st Aug
