+ Reply to Thread
Results 1 to 3 of 3

Counting unique values?

  1. #1
    Registered User
    Join Date
    11-06-2012
    Location
    Atlanta, GA
    MS-Off Ver
    Excel 2007
    Posts
    2

    Counting unique values?

    I'm stumped on how to count the number of unique values in a column. This may be a problems solved many times before so please excuse a new forum member while I figure this out. What I have (simplified) is a table with invoice number in alpha numeric form like D47223, and another column with the dates that notices have been sent about each invoice. Each invoice number may appear more than once depending on how many notices have been sent about that invoice - one or several times. How can I count the number of times each unique invoice number appears without regard for number of corresponing notices? The table has hundreds to thousands of entries so building a table for a COUNTIF function is not feasible. Thanks in advance.

  2. #2
    Forum Guru Bob Phillips's Avatar
    Join Date
    09-03-2005
    Location
    Wessex
    MS-Off Ver
    Office 2003, 2010, 2013, 2016, 365
    Posts
    3,286

    Re: Counting unique values?

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

  3. #3
    Registered User
    Join Date
    11-06-2012
    Location
    Atlanta, GA
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Counting unique values?

    Nice, I'll give it a try. Many thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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