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