Display the Number of Occurrences for Each Unique Date in a column

[TerryUSA]

I have a column of dates (Column A) with intermittent blanks and I need to display the number of occurrences for each unique date.




This is what I am starting with: (Note= The number of rows varies by project so I need the whole Column A referenced)

Dates
02-24-2013
02-24-2013
12-15-2012
11-26-2012
02-24-2013
02-24-2013
11-25-2012
11-25-2012

<tbody>
</tbody>

Column A= Dates​

This is how I envision it ending up:

Dates	Unique Dates	Number of Occurrences
02-24-2013	02-24-2013	4
02-24-2013	12-15-2012	1
12-15-2012	11-26-2012	1
	11-25-2012	2
11-26-2012
02-24-2013
02-24-2013
11-25-2012
11-25-2012

<tbody>
</tbody>

Column A= Dates
Column B= Unique Dates
Column C= Number of Occurrences for Adjacent Unique Date against Column A

​

Thanks in advance, Terry

 

[TerryUSA]

Nevermind, finally found it (Show Values As, Running Total In)