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
    Post Thanks / Like
    0 Post(s)
    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
    UK, West Sussex
    Post Thanks / Like
    1 Post(s)
    1 Thread(s)

    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