Feedback by UserVoice

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

Array formulae should work consistently

At present some functions can be used in array formulae and others cannot. And it seems rather hit and miss as to which can and which can. All inbuilt functions should deliver results across ranges which work with array functions

8 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

    Malcolm G shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    1 comment

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...
      • Daniel Smith commented  ·   ·  Flag as inappropriate

        Great idea. I am regularly frustrated that logical AND OR and NOT do not work in array formula , forcing unwieldy nested IFs. Also the complex operations such as improduct di not work which means that a simple set of complex operations has to be spread out over multiple cells instead of calculated in on array formula.

      Feedback and Knowledge Base