Hi,

Am Mon, 16 Sep 2013 10:10:21 -0700 (PDT) schrieb
:

If you could please provide me with a formula for this then that would be great.

in D107:
=SUM(OFFSET($C$1,MATCH(MAX($B:$B),$B:$B,0)-1,,-7))
in D108:
=AVERAGE(OFFSET($C$1,MATCH(MAX($B:$B),$B:$B,0)-1,,-7))


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2