Daily Count Functions

[yessir]

I have data that is formatted in two columns. One is the date and the other is a unique identifier. How can I calculate the number of times the unique identifier is trigged each day?

Day	Unique Identifier
12	1
13	2
12	1

This is a very short example of what I'm trying to achieve. I want to know that the unique identifier 1 is counted 2 times on the 12th. Subsequently the unique identifier 2 is only counted once on the 13th. Thanks.

 

[Cubist]

Have you considered pivot table?

 

[yessir]

Yes, I've completed it. Thanks, thought I would need more help.