Feedback by UserVoice

 

Viswanathan M B

← Welcome to Excel’s Suggestion Box!

My feedback

  1. Allow lookup functions to spill in two dimension

    1 vote
    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
    Viswanathan M B commented  · 

    @Roy, I agree Index function does the trick. But it would be great if Xlookup and Vlookup be allowed to produce array in two dimensions.

    Especially when the general buzz that Xlookup can replace index and match, then having to rely on index for 2D arrays looks like a bummer.

    Viswanathan M B supported this idea  · 
    Viswanathan M B shared this idea  · 

  2. 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
    Viswanathan M B commented  · 

    Can we also have MinRow, MinCol, MaxRow and MaxCol? As of now, the only way to do that is using an IF function, which, although intuitive, is not an ideal option.

    https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/39920671-minrow-maxrow-and-mincol-and-maxcol-as-part-of-dy

    Viswanathan M B supported this idea  · 

  3. MinRow, MaxRow and MinCol and MaxCol as part of dynamic array?

    2 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

    0 comments  ·  Excel for Windows (Desktop Application) » Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
    Viswanathan M B shared this idea  · 

  4. Add TopN optional parameter for new Dynamic Array functions

    8 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 →
    Viswanathan M B supported this idea  · 

  5. 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 →
    Viswanathan M B supported this idea  · 

  6. Aggregate 2D arrays by row or by column (especially relevant to dynamic arrays)

    7 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

    2 comments  ·  Excel for Windows (Desktop Application) » Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
    Viswanathan M B supported this idea  · 

  7. Pick color in Excel Like at Powerpoint

    1,124 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

    106 comments  ·  Excel for Windows (Desktop Application) » Formatting  ·  Flag idea as inappropriate…  ·  Admin →
    Viswanathan M B supported this idea  · 

  8. Add Corkscrew function for dynamic arrays

    20 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

    7 comments  ·  Excel for Windows (Desktop Application) » Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
    Viswanathan M B supported this idea  · 

Feedback and Knowledge Base

(thinking…)