Forum Discussion

Castellum812's avatar
Castellum812
Brass Contributor
Mar 02, 2022

Conver Google Array function

Hi There,

 

Have been struggling with this function for some time.

=ARRAYFORMULA(EOMONTH(TODAY();SEQUENCE(1;MAX(N2:N);-1))+1)

 

 

 

What is does.

Creates a header in a sheet containing the current month and subsequent month's  limited to a max.

Column N contains a number, 

 

How can I reproduce this in Excel?

 

One basic thin I struggle with is this "MAX(N2:N)"

In google it is very easy to have dynamic length of columns by simply leaving the row number out.

I currently solve this by creating a rang in excel but this is not Dynamic.

Is there another solution to do this?

 

 

 

 

 

 

excel
Formulas and Functions

1 Reply

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor
    Mar 02, 2022

    Castellum812 Perhaps this will work.

     

    =EOMONTH(TODAY(),SEQUENCE(1,MAX(N:N),-1,1))

     

     Use semi-colons in stead of commas the list separator is in your Excel set-up.

Resources