All 365 subscribers should have the dynamic arrays, except those on the semi-channel. @Kclynn
If you are not on the semi annual channel, it would be worth checking that you have all updates installed.
Some videos you may like
Excel Facts
What do {} around a formula in the formula bar mean?
I think the UNIQUE function is exclusive to O365 insider members currently and won't be released for a few months if I am correct.
I believe I have excel 365 in the office but due to the virus I am working at home on an older version. Just for my own knowledge if I have that function would the formula you provided work?
So if you had months number = 7, would you then fill Jan-Jul with figures, and put the final formula in for August?
I am not sure that I answer the question exactly. So yes, "if you had months number = 7, would you then fill Jan-Jul with figures, and put the final formula in for August?" but the start month would be based on the book date.
Couple of questions,
What is the max number of months an amount to be allotted? 12?
In your sample data, Which column in your data is Book date? Column O? If yes, then, why is your split filled from 'Jan' instead of from Oct?
Hi, I am not the creator of the document I am working on but I believe to start yes the number of months will be 12. Yes, the book date is in column O and if the dates started in the wrong month that was done in error. Should start with the month indicated in book date. Any advice is appreciated.
Can you re-do the post #7 manually, with the expected outcome i.e. months to be filled and months to be left blank and the month on which the balance need to be shown, so that I could write a formula with better understanding
I hope that is what you are looking for. I think it needs to include 24 months. Rolling year to year would even be better. But I just need to get the formula figured. Thank you for trying to help me. Wish I was better at this.
Couple more questions,
where does this 0.64 comes from? does that mean always 64% of amount to be distributed over x number of months mentioned in column P?
if the above is true , the balance to be placed in the cell next to last month would always be 36% of column I?
If the above is not true and the amount to be distributed over 12 months, then the numbers in your above example are not correct
Couple more questions,
where does this 0.64 comes from? does that mean always 64% of amount to be distributed over x number of months mentioned in column P?
if the above is true , the balance to be placed in the cell next to last month would always be 36% of column I?
If the above is not true and the amount to be distributed over 12 months, then the numbers in your above example are not correct
This is would be correct.
where does this 0.64 comes from? does that mean always 64% of amount to be distributed over x number of months mentioned in column P?
if the above is true , the balance to be placed in the cell next to last month would always be 36% of column I?