Results 1 to 8 of 8

Count of distinct (unique) values by day

Threaded View

  1. #1
    Registered User
    Join Date
    12-05-2011
    Location
    Austin, TX
    MS-Off Ver
    Excel for Mac 2011
    Posts
    2

    Unhappy Count of distinct (unique) values by day

    Hi all,

    Thanks in advance for any assistance you can render. I've been wrestling with this issue for the last hour, and haven't made much headway.

    I've got a spreadsheet in the following format:

    Date / Name / Date / Unique Names
    Jan1 / Sue / Jan1 / 2
    Jan1 / Bob / Jan2 / 1
    Jan1 / Sue / Jan3 / 3
    Jan2 / George
    Jan2 / George
    Jan3 / Bob
    Jan3 / George
    Jan3 / George
    Jan3 / Sue

    I want to automatically perform the count for the number of unique names on a given day, as I'm dealing with roughly 6000 entries over the past year. In other words, I'd like to count how many unique (distinct) names appear on January 1, on January 2, on January 3, and so forth.

    Again, many thanks in advance for any assistance y'all can offer!
    Last edited by velorian; 12-06-2011 at 04:28 PM.

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