Forum Discussion

Copper Contributor

Apr 02, 2020

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

SergeiBaklan
Apr 02, 2020
Johns_Corner

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)*C3

and assuming division of number on average returns integer.
Sales on months.xlsx24 KB

Diamond Contributor

Apr 02, 2020

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)*C3

and assuming division of number on average returns integer.

Sales on months.xlsx24 KB

Johns_Corner
Copper Contributor
Apr 03, 2020
SergeiBaklan Thank you very much
- SergeiBaklan
  Diamond Contributor
  Apr 03, 2020
  Johns_Corner , you are welcome
  - Johns_Corner
    Copper Contributor
    Apr 03, 2020
    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?

Resources