| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
counting duplicates
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| counting function but not double counting duplicates | Excel Worksheet Functions | |||
| Counting Names in a Column, Ignoring Duplicates | Excel Discussion (Misc queries) | |||
| Counting duplicates | Excel Discussion (Misc queries) | |||
| Counting and duplicates | Excel Discussion (Misc queries) | |||
| counting duplicates Among Many Sheets, Possible?? | New Users to Excel | |||
Threaded Mode
