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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.