I'm desperately looking for a formula which will return the same values I have in line 9 of my example.xls sheet.
It simply returns the number of cells between two cells in a timeline, which actually have values (not zero), like in line 4.
So as an example: there is a value in E4 and then zeros until J4. I need the cells in E9 to I9 to tell me that there are 5 periods between the two.
Thanks a lot for your help.
example (1).xlsx
Bookmarks