Day Temp (F) 7/1/2011 89 7/2/2011 88 7/3/2011 92 7/4/2011 101 7/5/2011 94 7/6/2011 97 7/7/2011 95 Formula Description Result =RANK.AVG(94,B2:B8) Finds the rank (the position) of the value 94 in the cell range B2:B8. In this case, 7/5/11, when the temperature ...