Hello,

I am looking for a formula that can help me whit the next question:
In column C are dates and i want to know the frequency in Column B,
I inserted column B, because text is not handy. I want to now the
count/frequency and not the sum.

Example 1: I want to know for 16 january, the count of Column B (=3) and
afterwards i want in column D -1, so the result is 2 (in column D).

Example 2: 23 january, it are three rows, it contains number 3 twice, so i
want to know that the count/frequency is 2, and also -1, which result in 1
(in column D).

I hope that somebody can help me with this and give me a correct formula. I
spend a lot of time, but could not find the right formula.

Regards,

Paul

A B C D = Result
AB 1 1/9/09 0
AS 2 1/16/09 2
AB 1 1/16/09
DS 3 1/16/09
AB 1 1/23/09 1
DS 3 1/23/09
DS 3 1/23/09
AB 1 1/30/09 1
AS 2 1/30/09
AB 1 2/6/09 0
AB 1 2/13/09 0
AB 1 2/20/09 1
IT 4 2/20/09
AB 1 2/27/09 0
AB 1 3/6/09 0
AB 1 3/13/09 1
AS 2 3/13/09
AB 1 3/20/09 0
AS 2 3/27/09 1
AB 1 3/27/09