Excel
Thank you so much - will try it shortly
"Anu" wrote:
Use a Pivot table for the same. In the row area place the scheme code. In the
data area place the rateable values. Double click to change sum to average.
Finish the wizard and you will have what you want
Anu
"JillyB" wrote:
I have a column of scheme codes, with the same codes repeated through the
list eg. 123, 456, 123, 678, 456, 123 and a column of rateable values. I
need to work out the average rateable value for same group of codes e.g. for
all the 123 codes. Can you help please if this is possible.
Thank you
|