Hi,

Am Wed, 21 May 2014 13:07:00 +0100 schrieb Curios101:

I have 2 columns (A & B). A houses "dates" and B houses corresponding
"numbers". Dates are all 1 week apart but data for some weeks in between
might be missing.

I need to look up the numbers for a certain week of the month for last
"n" years and calculate min, max and average in columns C, D and E
respectively.

please have a look:
https://onedrive.live.com/?cid=9378A...121822A3%21326
for "StatisticsForWeeknum"


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional