Results 1 to 7 of 7

Trying determine the number of unique occurances

Threaded View

  1. #1
    Forum Contributor
    Join Date
    10-07-2011
    Location
    Plano, TX USA
    MS-Off Ver
    Excel 2013
    Posts
    141

    Trying determine the number of unique occurances

    Hi To All-

    I am having trouble trying to develop a formula that will count the unique months for a given ID.

    Two sheets, the first has the Unique ID and that is where I want the formula.

    The second sheet has one to multiple entries for each unique ID on sheet 1

    I have attached a worksheet showing what I am trying to do. I've played around with this all morning, search the Web but haven't found the answer.

    Any help you can give me will be extremely appreciated.

    Thanks,
    Jim
    Attached Files Attached Files
    If I was able to help you, I would appreciate your reputation feedback by using the * icon in the lower left.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Creating unique id's for repeat occurances
    By Nickyh1984 in forum Excel Formulas & Functions
    Replies: 23
    Last Post: 06-05-2014, 06:03 PM
  2. [SOLVED] Count the number of unique values (occurances) in a range.
    By angelopc in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-13-2013, 10:36 AM
  3. Replies: 5
    Last Post: 08-26-2008, 01:07 PM
  4. How to count unique occurances linking two columns
    By nebula786 in forum Excel General
    Replies: 1
    Last Post: 06-29-2007, 01:19 AM
  5. Count # of unique occurances
    By sharder in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-29-2006, 12:45 AM

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