I have a column of dates listed as text as the following, 20020402 standing for April 4 2002. I would like to count in the column next to the date column,how many of that date there are.
For example
column A column B
20020402 1
20020402 2
20020402 3
20020403 1
20020403 2
20020404 1
20020404 2
20020404 3
20020404 4
Any help would be greatly appreciated.
For example
column A column B
20020402 1
20020402 2
20020402 3
20020403 1
20020403 2
20020404 1
20020404 2
20020404 3
20020404 4
Any help would be greatly appreciated.