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!
Bookmarks