Unique counts of a values/logins 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.

Originally Posted by Miraun

If you highlight both columns, you can use the "Remove Duplicates" option under Data.

Alternatively, another option would be to concatenate the two values. So that you're left with a horrible looking 6089015/1/2014. What you can then do with that value is to just do a simple Countif() function across the entire set of data, which will highlight multiple hits per day for deletion.

Editted to add: In Excel 2003, you may need to use an Advanced Filter for Unique Results only. As long as Both fields are highlighted, it should treat A1&B1 as a unique value, rather than only unique values in A:A and only unique values in B:B

That's a good idea about concatenating the columns. Then I could just separate them and get the unique values.

So if I highlight both columns and use Remove Duplicates, it will only remove those instances where two cells in the same row are the same? It won't for instance remove all instances of 5/1/2014 or 680717?

Originally Posted by oeldere

Looks like a pivot table, can help you get the desired result.

A small excel will help you getting an better answer.

I looked into using a PT but I was under the impression I had to assign a count to each occurrence/row before doing that. Basically, I'd have to give a count of 1 to the unique combination of ID and Date and 0 to any duplicates. I know you can remove duplicates in the PT but wasn't sure that accomplished what I needed. Can you provide a link to what you are suggesting to study up on?