I am working on the attached worksheet and was able to create a report showing profit from different locations 18 months from the date each location was resold(18 MO After tab). I want to be able to also look 18 months back from the resale date to see if there has been an improvement.
I thought the easy answer was to change the formulas for the month and profit would give me the results but it didn't work. How would I get the prior 18 months?
Jerry, I suspect the reason you didn't get an answer to this is because you posted a complex workbook. Simplify it down to just a few fields and repost, and I'm sure someone will come up with an answer for you. (I won't, as I don't do text tables any more.)
EDIT: Also call it something other than TTM, I still don't know what that's an abbreviation for.