Hi there,
I have a table with list of amounts for each month.
I am trying to get the value from the last, most recent month (first from the right) which is not zero.
My formula works mostly, but returns incorrect figures where multiple sets of zero gaps are.
Please refer to the attached spreadsheet:
The formula is in column 'O'.
Basically I need the amount in the most recent month which is not zero.
I marked the incorrect amounts returned via red font color. Expected correct figures in column 'R'.
Column 'P' has a variation of the same formula, hence of course an incorrect result too.
Here I am after the average of the last 2 months before we have zero amounts. Expected correct figures in column 'S'.
Any help, suggestions would be greatly appreciated.
Bookmarks