Forum Discussion
Solved
Need help how to do this
I don’t know how to explain it so here is a screenshot of what I want to happen
If you are on Excel with dynamic arrays that could be
with
=EDATE(C5,SEQUENCE(C2/C3)-1)and
=SEQUENCE(C2/C3,1,1,0)*C3and assuming division of number on average returns integer.
9 Replies
Thanks for your replies. Here is what I did.
Johns_Corner This is possible in Office 365 using dynamic arrays; example attached. This sort of thing is possible in Google Sheets or Office 356 but not in earlier versions of Excel.
- Thank you
If you are on Excel with dynamic arrays that could be
with
=EDATE(C5,SEQUENCE(C2/C3)-1)and
=SEQUENCE(C2/C3,1,1,0)*C3and assuming division of number on average returns integer.
SergeiBaklan Thank you very much
Johns_Corner , you are welcome
