Evening All
I am trying to capture information around hours worked.
I have 104 columns of data (weeks numbered 1-104).
All Rows have numerous zeros as well as a range of figures (some weeks worked, others not).
Some Rows have less than 52 values that are greater than zero, others have more than 52.
On each Row, I need to know the Sum the most recent <52 values that are greater than Zero - is this possible?
Many Thanks
Jax
Bookmarks