Count duplicate value in previous rows

Hi Guys,

I know countif function will help find out duplicate values. But now I need to find a way to do something like below. So the result field will add up with value in previous rows being duplicated.

Value Duplicate(with countif) Result
1 0 0
2 0 0
2 1 1
3 0 0
1 0 0
2 1 2
4 0 0
3 1 1
6 0 0

Is there anyway to make this happen?

Thanks for the help!
Alan

Thanks L-Drr:

I used your recommendation (=COUNTIF(A2:$A$10,A2)-1) and achieved below result. I am hoping to achieve the Desired Result shown as below. Is it possible?


Value Result Desired Result
1 4 0
1 3 1
1 2 2
1 1 3
2 1 0
1 0 4
2 0 1



Thanks!
Alan

Hi Alan,

Thanks! it works great!

Alan