Mr Retirement
New Member
- Joined
- Nov 12, 2016
- Messages
- 46
Hi Everyone -
This might be explained easiest by the sample table below. I'm looking for a formula that will take my inputs (Month & Year) and return the value from the last available date in that month/year from the table.
<tbody>
</tbody>
Any help would be appreciated
Thanks,
Mr R.
This might be explained easiest by the sample table below. I'm looking for a formula that will take my inputs (Month & Year) and return the value from the last available date in that month/year from the table.
Month: | 3 | |
Year: | 2013 | |
NEEDED FORMULA: | 1563 | |
Data: | ||
Helper Column (if needed) | Date | Value |
03201301 | 3/1/2013 | 1500 |
03201304 | 3/4/2013 | 1502 |
03201315 | 3/15/2013 | 1505 |
03201328 | 3/28/2013 | 1563 |
04201303 | 4/3/2013 | 1600 |
etc... |
<tbody>
</tbody>
Any help would be appreciated
Thanks,
Mr R.