Results 1 to 2 of 2

Thread: Unique counts of a value per day
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    May 2014
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Unique counts of a value per day

    I have a pretty simple spreadsheet with two columns. In Column A is a unique identifier for a user (608901, 505141, etc.). In Column B is a date the user logged in (5/1/2014). For a week's span there are about 25k rows.

    Users can and do log in multiple times per day creating duplicate entries for a single day (680717 might show up 3 times for 5/1/2014). What I need to figure out is how to get a count of all unique logins per day. So if 680717 in previous example logged in 80 times on 5/1/2014, that only counts as 1 unique login for 5/1/2014.

    I'm at a freakin loss with this. Searched everywhere and just can't get it.

  2. #2
    Board Regular etaf's Avatar
    Join Date
    Oct 2012
    Location
    UK, West Sussex
    Posts
    3,379
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    1 Thread(s)
    Wayne

    Using Excel Version 365 for Mac

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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