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 -
<tbody>
</tbody>
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
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 | Nothing | 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 | |
<tbody>
</tbody>
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