Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Dec 2006
    Posts
    250
    Thanks
    0
    Thanked 0 Times in 0 Posts

    formula to count unique numbers

    Hello-I need to create a formula that counts unique values in rows. I know I can use the filter option, but need to create a formula. For example
    Row1 "david"
    Row2 "david"
    Row3 "Jessie"
    Row4 "Jon"

    3 unique values. Any help would be great. Thanks.

  2. #2
    5 Star Lounger
    Join Date
    Jan 2004
    Location
    Praha
    Posts
    988
    Thanks
    56
    Thanked 105 Times in 90 Posts
    Take a look at the second part of this linked article: http://office.microsoft.com/en-us/ex...ique_values_by_

    Note how you enter Array formulas.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •