Feedback by UserVoice

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

Dynamic Array Function Suggestions

The current UNIQUE function should be modified to align with industry meaning. For example, in SQL and also in the Power Query Fuzzy Lookup functions, UNIQUE has a meaning OPPOSITE to the Excel function. In both cases, UNIQUE refers to values that occur only ONCE in a dataset.

In addition, distinct should not be mixed into the same function. DISTINCT should be a separate function, which refers to values that occur more than once in a dataset (from which we want to extract distinct values).

Add a new TOPN function. This function would work independently of SORT (a function should do just one thing). An option would allow ties to be included.

1 vote
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 →

    1 comment

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

        The proposed modification to the UNIQUE function and the addition of DISTINCT and TOPN are natural feedback suggestions with respect to the new and unreleased Dynamic Array functionality.

      Feedback and Knowledge Base