The formula "=COUNTIF(D:D,D1)" looks at the entire two column and and then
outputs number of repeating numbers.
What I want is, it look in col. B and if numbers gets changed it start the
calculation again.
For example if I have same number in two different places of my range it will
add them together which I don't want.
Is there anyway to do this?

thx.

For example:

I have:

A B
256 256
256 256
256 256
345 345
789 789
631 879
436 789
523 282
523 282
256 256
256 256
256 256

I want:

A B C
256 256 3
345 345 1
789 789 1
631 879 1
436 789 1
523 282 2
256 256 3 <=== Instead of 6

saman110 wrote:
I have numbers in two columns like A and B. How can I get the number of
duplicates in column C and delete the rest.

I have:

A B
256 256
256 256
256 256
345 345
789 789
631 879
436 789
523 282
523 282

I want:

A B C
256 256 3
345 345 1
789 789 1
631 879 1
436 789 1
523 282 2

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200802/1