Hi,

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.

I have tried different combinations of vlookup, index, match etc. but to no avail.

Please assist (or is there a better/ easier way of using some other formula/ function). I have attached the file as a zipped file.