I have a spreadsheet with 12 columns (B2:M2), that represent the months of the year. The columns of each row will either be blank, or contain a numeric value for a given month.
What I'm trying to do, is get the last non-blank cell, and compare it to the previous non-blank cell.
So for example: If B2 (which represents January) has a value of 24, and H2 (Which represents July) has a value of 30, and all other cells in that row are blank. Then the value I'm trying to calculate would be +6.