Tuesday, September 4, 2012

yogi_Compute In Column G Average Of values In Column C Based On Standings In Column D

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #733   Sep 04, 2012     www.energyefficientbuild.com.

user meph2u said: (http://productforums.google.com/forum/?zx=alk42vs49d24#!category-topic/docs/spreadsheets/sBi3-oPax2M)
How to lookup up values depending on Averaging when Duplicates (ties) exist
Two questions....
1) is there a simpler or more elegant way of stripping the "T"s from column D than the formula in E3  =arrayformula(if(left(D3:D)="T",Value(replace(D3:D,1,1,"")),D3:D))

2) the real reason for this post - how can I fill out Column G based on the values in Column C when ties are averaged (see examples in column H)?
following is a solution to the problem