Creating a frequency table for each recurring date

[mukayi]

Can someone help with this one. I have a list of dates in column G.

G
1/15/12
1/15/12
1/15/12 frequency for 1/15/12 should be here (i.e. 3)
1/16/12
1/16/12 frequency for 1/16/12 should be here (i.e. 2)
1/17/12
1/17/12
1/17/12
1/17/12

Each date occurs a mutiple number of times. I have sorted the data to show the oldest date at the top and the newest date on the bottom. I want a function that calculates the frequency of each date in the adjucent column, F, and possibly put the frequency of each date in the cell adjucent to where each date ends. I used =COUNTIF(G:G,"11/15/12"). It works but I have to go to the end of each date and change the criteria.

Thank you

[Richard Buttrey]

Hi,
In B1 and copied down

Please Login or Register  to view this content.

Change the last row ref of 100 as appropriate

[zbor]

Here, try this in H1:

=IF(G1<>G2, COUNTIF(G$1:G1, G1),"")

Edit: If you need total number of dates use above approach
If you need "up to date" use mine (for example, try to enter 1/15/12 at the end of your data ans see both results)