Hello,

I have a problem and i dont really know how to fix it. I have a column with some dates all distanced by one week -

Date Number
7 jan 2001 50
14 Jan 2001 65
21 Jan 2001 70
28 Jan 2001 68
4 Feb 2002 70
11 Feb 2002 42
18 Feb 2002 46
25 Feb 2002 29


I would like a formula that based on the month and year will return the last value it can find for this month and year - So if we have Jan & 2001 it will return 68 (last week), Feb & 2001, it will return 29 (last week).
The month could sometime be 4 or 5 weeks long so it is really the last value of the month.

Thanks so much for your help