Vlookup an array and report min, max and average as a result
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.
|