+ Reply to Thread
Results 1 to 3 of 3

Count Number of Unique Values in an Array

  1. #1
    Registered User
    Join Date
    01-18-2021
    Location
    california, united states
    MS-Off Ver
    MS365 (PC) Version 2209
    Posts
    39

    Count Number of Unique Values in an Array

    Hi all,

    This seems simple enough but I'm having trouble finding this solution anywhere. I have a table column populated with data values that can repeat. I can extract these unique values in an array formula using:

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Which will produce a list of all the unique values, excluding repeats. Is there any way I can determine the total number of unique values? For instance, say the above formula returns 54 rows of unique values. Is there a formula that will return the number 54?

    Thanks so much in advance!

  2. #2
    Registered User
    Join Date
    01-18-2021
    Location
    california, united states
    MS-Off Ver
    MS365 (PC) Version 2209
    Posts
    39

    Re: Count Number of Unique Values in an Array

    I figured it out

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Cheers~

  3. #3
    Forum Expert
    Join Date
    09-07-2014
    Location
    Israel
    MS-Off Ver
    office 365 for MAC
    Posts
    3,105

    Re: Count Number of Unique Values in an Array

    Try to wrap it with the COUNT function (if the values are numbers, and COUNTA if they are text strings.
    =count(UNIQUE(Table1[Column1]))

+ 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 number of unique values corresponding to unique data in another column
    By STUARTXL in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-26-2019, 12:32 PM
  2. [SOLVED] SUMIF array formula to count unique values after a certain date
    By CakeMish in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-13-2015, 09:24 AM
  3. [SOLVED] Count unique values based on criteria but without array formula (CSE)
    By Villalobos in forum Excel General
    Replies: 3
    Last Post: 05-09-2015, 05:05 AM
  4. [SOLVED] Count unique values based on criteria without using array
    By jonpaulson in forum Excel General
    Replies: 14
    Last Post: 10-10-2014, 06:30 PM
  5. [SOLVED] Count number of unique names in a filtered list (non array)
    By IN_FOR_SIN in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 01-31-2014, 04:07 AM
  6. [SOLVED] Count unique values in list but NOT using ARRAY formula
    By alx0101 in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 03-15-2013, 08:15 AM
  7. Extract unique values and their count from a two dimensional Array
    By shahirslmn in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-17-2012, 09:37 PM

Tags for this Thread

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