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.
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
SergeiBaklan Hello again. Sorry to bother you so much but here is another situation in which I want to start the sequencing basing from the date I entered. Is this possible?
If you have pre-define list of months, perhaps it'll be easier to use more traditional formula. For this sample
enter into G8
=IF(EOMONTH(F8,0)<EOMONTH($H$2,0),0,IF(EOMONTH(F8,0)>=EOMONTH($H$2,$H$4),0,$H$3/$H$4))and drag it down