Showing Continuous Trend even with Gap Data
For context, I am trying to show month by month trend, but there are some months where there are no data.
Right now, my trend column (#3) compares the data(Column #1) in the current row to the row right below it. For rows where the row below has no data, is there a formula to get it to skip the empty row and compare it to the next row with data?
Help Article Resources
Check out the Formula Handbook template!