count the number of times a date is shown.

[brianflieck]

i have a list of files with dates associated. i'd like to simply count the number of times each date is being shown.

for example, 1/2/18 is shown below 10 times. I have this for an entire calendar year.

1/2/18

1/2/18

1/2/18

1/2/18

1/2/18

1/2/18

1/2/18

1/2/18

1/2/18

1/2/18

1/3/18

1/3/18

1/3/18

1/3/18

1/3/18

1/3/18

1/3/18

1/3/18

1/3/18

1/3/18

1/3/18

1/3/18

1/3/18

1/3/18

1/3/18

1/3/18

1/3/18

1/3/18

1/3/18

1/3/18

1/3/18

1/3/18

1/3/18

<colgroup><col></colgroup><tbody>
</tbody>

 

[alansidman]

Employ the countif function. If you have your list in column A and a list of the calendar dates in column E, then in column B

=COUNTIF($A$1:$A$33,E1) and copy down.

If you wish to put the dates in manually then,

=COUNTIF($A$1:$A$33,"1/2/2018")