Feedback by UserVoice

# Anonymous Coward

1. ## SUMCOLS and SUMROWS functions for Dynamic Arrays

(thinking…)
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. ## Create Array that joins two arrays

(thinking…)
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. ## LAMBDA functions and recursion -- calling a SELF function?

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

Anonymous Coward shared this idea  ·
4. ## Add Center Across Selection to the Merge & Center Drop-down

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

Thanks for supporting the suggestion to add the Center Across Selection option to the Merge & Center dropdown. We agree this is a nice idea. Please add your vote if you’d like to see this change.

Thanks – Steve K {Excel]

Anonymous Coward supported this idea  ·