Moving quarters (offset)

[brems]

Hi,

I'm trying to find a solution for a simple challenge (aka problem).

In a chart I'm displaying 8 quarters of data. (2014 en 2015)
As soon as the first quarter of 2016 starts the oldest value (2014 Q1) must be omitted and the new value (2016 Q1) must be added.
Each start of a new quarter: the oldest quarter must be omitted and the new quarter needs to be added.

I added an example file.

Thank you very much in advance for your kind assistance.
Wim

 

[Xiq]

Hi brems,

As soon as the first quarter of 2016 starts

We are still in 2013!! Do we have to wait that long before the requested formula is actually starting to function??

 

[Debraj]

Hi brems,

can you check the attached.. and confirm, is this what you are looking for..

formula used as...
=INDEX(B$3:B$100,MAX(IF(ISNUMBER($B$3:$B$100),ROW($B$3:$B$100)))-10+ROW(A1:A8))

 

[brems]

Hi Debraj,

Unfortunately I can one click 'like' once. )

Fortunately this is EXACTLY what I was looking for.
Thank you very much!!

Wim

 

[brems]

I have an additional question.
I'm trying to understand the used formula but at the moment it's still to abstract. Can you point me to some recommended reading?
Especially the use of ROW isn't very clear.
Thanks!