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).

4 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