Hi! Below is the sample data:

Column A Column B
Date Registration #
2014-03-06 308011
2014-03-06 308011
2014-03-06 308035
2014-03-06 308047
2014-03-07 308011
2014-03-07 308035
2014-03-07 308035
2014-03-07 308035
2014-03-08 308011
2014-03-08 308035
2014-03-08 308047
2014-03-08 308047



I need total new registrations on each day (Unique values only) as below:

Date Total New Registration
2014-03-06 3
2014-03-07 2
2014-03-08 3

I have tried different formulas but can't seem to get the desired result. Any help would be appreciated!