Feedback by UserVoice

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


Proposal for a built-in function for: Count distinct/unique values in a range

There might be a dedicated function for counting distinct values in a specific range.
Currently the following function is a solution:

However beginner-level users would like probably a predefined parametric function, sg like this:

Thank you.

42 votes
Sign in
Sign in with: Facebook Google
Signed in as (Sign out)

We’ll send you updates on this idea

Peter Szmodics shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →


Sign in
Sign in with: Facebook Google
Signed in as (Sign out)
  • Ed Hansberry commented  ·   ·  Flag as inappropriate

    @sergie - Mac, iOS, and iPadOS all have Dynamic Array functions for Insiders. Not sure about Android, but it will if it doesn't now.

  • Sergei Baklan commented  ·   ·  Flag as inappropriate

    Hi Peter - it is on Excel desktop for Windows if you are Office 365 subscriber and Insider Fast. Not sure when it'll be deployed for other channels. That functionality won't be for Excel 2019, have no idea about Excel for Mac.

  • Peter Szmodics commented  ·   ·  Flag as inappropriate

    Hi Sergei, it seems to be a nice solution, as I see it will be working in Excel for Office 365, will it be rolled out on desktop as well? Thank you.

    My approach could assist probably the beginner-level users.

Feedback and Knowledge Base