Count the number of times a date occurs and make a graph from it

Question

I have a list of dates, each date in it can occur several times. I want to count the number of times when each date occurs (histogram), and display it on the graph (with the Y axis being the number of times the date occurs, and the X axis the date itself)?

List example:

19/05/2012 19/05/2012 19/05/2012 17/05/2012 17/05/2012 16/05/2012 16/05/2012 16/05/2012 16/05/2012 15/05/2012 15/05/2012 15/05/2012 15/05/2012 12/05/2012 12/05/2012 12/05/2012 7/05/2012 

Answer 1

The simplest is to make PivotChart. Select your date array (with title) and create a new pivot chart (Insert / PivotChart / Ok) Then, in the field list box, first drag the date column into the axis list and then into the list of values.

Step 1:

Step 2:

Answer 2

If you have Excel 2010, you can copy the data to a different column than select it and select "Data" → "Delete Duplicates". Then you can write =COUNTIF($A$1:$A$100,B1) next to it and copy the formula down. This assumes that you have values ​​in the range A1:A100 , and deduplicated values ​​in column B.