Formula Help

[Formulahelp]

Hello,
Can anyone tell me if this is possible?

Current Situation: I have a chart similar to cells B1:U3. However, I only have to populate the chart one month at a time so I just make a copy of the existing month and paste it to a new column. For example, in April, the columns only go to Column O. After April, I copy Column O and create May in Column P. At that time, my offset formula in Column S works to show the difference from May to April. However, I would like to know if it is possible to already create a template with all of the months and just fill in the appropriate month as needed. I will still need to calculate the difference from current month to previous month. However, is it possible to set up a formula in Column S that will automatically calculate the last month populated minus the previous month populated? If so, what would the formula look like? See image below for additional details. Thank you in advance for your help.

 

[SanjayGMusafir]

Welcome to the forum

I think what you are asking can be done. Share XL2BB of the sample sheet to help you better

Use the link below to find details on how to install

 

[hagia_sofia]

Would this work for you:

=LET(
array,C16:Q16,
INDEX(array,,XMATCH(TRUE,ISBLANK(array))-1)-INDEX(array,,XMATCH(TRUE,ISBLANK(array))-2))

=INDEX(C16:Q16,,XMATCH(TRUE,ISBLANK(C16:Q16))-1)-$C$16

 

[Formulahelp]

Would this work for you:

=LET(
array,C16:Q16,
INDEX(array,,XMATCH(TRUE,ISBLANK(array))-1)-INDEX(array,,XMATCH(TRUE,ISBLANK(array))-2))

=INDEX(C16:Q16,,XMATCH(TRUE,ISBLANK(C16:Q16))-1)-$C$16

Sofia,
Oh my gosh!!!!!! These formulas worked perfect. I cannot thank you enough for your help.
Very much appreciated.
Have a nice day!!