Comparing the most recent two quarters
I have sheet collecting total cost dollar figures as they are entered each quarter (over a three year period, so 12 quarters total) into another sheet.
The accounting system is accrual based, so each quarter the dollar amount should/must increase. I'm trying to figure out a formula to automatically compare the most recent quarter entered and compare it with the previous quarter to indicate if the amount in the most recent quarter decreased. My plan was to indicate this in the parent row (total cost), but I can't figure out the best way to create a formula that will recognize the most recent quarter and compare it with the previous. I attached a screenshot so you can see how the sheet is setup.
Thanks for the help,
Help Article Resources
Check out the Formula Handbook template!