Feedback by UserVoice

 

Anonymous Coward

← Welcome to Excel’s Suggestion Box!

My feedback

  1. SUMCOLS and SUMROWS functions for Dynamic Arrays

    285 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    43 comments  ·  Excel for Windows (Desktop Application) » Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
    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

    17 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    4 comments  ·  Excel for Windows (Desktop Application) » Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
    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?

    3 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    1 comment  ·  Excel for Windows (Desktop Application) » Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
    Anonymous Coward shared this idea  · 

  4. Add Center Across Selection to the Merge & Center Drop-down

    880 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    107 comments  ·  Excel for Windows (Desktop Application) » Formatting  ·  Flag idea as inappropriate…  ·  Admin →
    Anonymous Coward supported this idea  · 

  5. Name a dynamic array (rather than use "A1#" notation)

    13 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    1 comment  ·  Excel for Windows (Desktop Application) » Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Anonymous Coward commented  · 

    yes please!! even something like departments#

Feedback and Knowledge Base

(thinking…)