Forum Discussion

Johns_Corner's avatar
Johns_Corner
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
excel
  • SergeiBaklan's avatar
    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.

Savia's avatar
Savia
Iron Contributor
Apr 02, 2020

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.

Johns_Corner's avatar
Johns_Corner
Copper Contributor
Apr 03, 2020
Thank you

Resources