+ Reply to Thread
Results 1 to 7 of 7

Formula to count unique numbers in a string

  1. #1
    Forum Contributor
    Join Date
    06-18-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    104

    Formula to count unique numbers in a string

    I have a large spreadsheet where each row is a unique field and that field more often than not has the same number over and over again. However, there are instances where the number will change somewhere in the array. Is there an equation to count how many unique numbers are in an array?

  2. #2
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: Formula to count unique numbers in a string

    Please post some sample values and the results you want to see...based on the sample.
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules

  3. #3
    Forum Contributor
    Join Date
    06-18-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    104

    Re: Formula to count unique numbers in a string

    Unique numbers.xlsx





    Here is a very boiled down version of what I am working with.

  4. #4
    Forum Contributor
    Join Date
    08-14-2014
    Location
    US
    MS-Off Ver
    2013
    Posts
    135

    Re: Formula to count unique numbers in a string

    Is this something that would work?
    =SUM(IF(FREQUENCY(B3:H3,B3:H3)>0,1))
    shows 2 unique types for your sample in row 3

  5. #5
    Forum Contributor
    Join Date
    06-18-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    104

    Re: Formula to count unique numbers in a string

    Very neat. That certainly helps. Is there a way to show what the unique values are? So have row 3 say 26 in column I and maybe have 35 in column K?

  6. #6
    Forum Contributor
    Join Date
    08-14-2014
    Location
    US
    MS-Off Ver
    2013
    Posts
    135

    Re: Formula to count unique numbers in a string

    I am not sure on that one someone with more experience would need to help you.

  7. #7
    Forum Contributor
    Join Date
    08-14-2014
    Location
    US
    MS-Off Ver
    2013
    Posts
    135

    Re: Formula to count unique numbers in a string

    After some help ScottBeatty think this is what you wanted. Some columns are hid to keep it clean and make it easier to accomplish the goal.
    Attached Files Attached Files

  8. #8
    Forum Contributor
    Join Date
    06-18-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    104

    Re: Formula to count unique numbers in a string

    Very interesting, thank you!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Count numbers between two values in a coma delimited string of numbers
    By van23 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-10-2012, 11:42 PM
  2. Count Unique Text String
    By hecgroups in forum Excel General
    Replies: 11
    Last Post: 11-17-2012, 12:50 PM
  3. returning count of unique occurences of a string from a range.
    By tinkerbelle in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-10-2011, 04:50 PM
  4. Count unique characters in a string
    By yelkus in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-25-2007, 11:46 AM
  5. [SOLVED] Need help, how to increment numbers for each unique text string.
    By tHeRoBeRtMiTcHeLL in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-05-2005, 04:05 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1