Feedback by UserVoice

Anonymous Coward

My feedback

  1. 285 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Anonymous Coward commented  · 

    Apparently this has always been possible with CSE's

    =MMULT(COLUMN(OFFSET($A$1,,,,ROWS(Matrix)))^0,Matrix)

    Anonymous Coward supported this idea  · 
    An error occurred while saving the comment
    Anonymous Coward commented  · 

    Make UDFs

    SUMCOLS(x) = MMULT(SEQUENCE(1,ROWS(x),1,0),x)

    SUMROWS(x) = MMULT(x,SEQUENCE(COLUMNS(x),1,1,0))

  2. 17 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Anonymous Coward commented  · 

    CombineArraysVertically=LAMBDA(x,y,LET(m,ROWS(x),n,ROWS(y),p,COLUMNS(x),i,SEQUENCE(m+n),j,SEQUENCE(1,p),IF(i<=m,INDEX(x,i,j),INDEX(y,i-m,j))))

    CombineArraysHorizontally=LAMBDA(x,y,TRANSPOSE(CombineArraysVertically(TRANSPOSE(x),TRANSPOSE(y))))

  3. 3 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Anonymous Coward shared this idea  · 
  4. 880 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Anonymous Coward supported this idea  · 
  5. 13 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Anonymous Coward commented  · 

    yes please!! even something like departments#

Feedback and Knowledge Base