Feedback by UserVoice

How can we improve Excel for Windows (Desktop Application)?

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

The new dynamic array notation is incredibly powerful, but one thing that makes formulas complicated is the "A1#" notation when used in formulas.

It would be great if you could (easily) assign a name to it in the same way that you can name an Excel table.

It would be much easier to see:

=SUMIFS(TABLE1[totals],TABLE1[dept],departments)

than

=SUMIFS(TABLE1[totals],TABLE1[dept],B1#)

I am able to define a named range for these values, but that is a bit clunky. It would be great if the naming was exactly the same as Table naming (e.g. in an ARRAY context menu like the TABLE context menu).

10 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Anonymous shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    0 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...

      Feedback and Knowledge Base