I need a formula that will provide me the trailing 4 quarters based on current quarter. So if we are in Q3-2016, then i need formula that will spit out Q4-2016, Q1-2017, Q2-2017 and Q3-2017.
I have attached an example book that uses a Named Range of values and then uses Index and MOD to find the next 3 values within that range. I made and example for both rows and columns. It is basically the same as the method illustrated here: http://chandoo.org/wp/2010/04/06/rolling-months/