Anonymous

My feedback

  1. 68 votes
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)

      We’ll send you updates on this idea

      Anonymous commented  · 

      I posted this on another page not realizing that others requested; thank you Liz for the link.

      (http://answers.microsoft.com/en-us/office/forum/office_2010-excel/create-a-function-distinct/3a7a3697-ec1b-48f9-b64f-15d0a409e06b)

      =distinct() or =countdistinct() need not be an array; it can be a straight formula that would count the amount of unique numbers.

      =duplicate can be the opposing function.

      It is so basic; let's make life easier than these complicated multi layer functions currently required to get this done.

      Anonymous supported this idea  · 
    • 9 votes
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        I agree to the terms of service
        Signed in as (Sign out)

        We’ll send you updates on this idea

        Anonymous supported this idea  · 

      Feedback and Knowledge Base