| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Total Number of Dups in 2 columns
Hello!
I have two sets of data in Columns A and B. I want to find out the total number of duplicate between columns A and B. I just want the know the total number of duplicates without copying down in another column. In the example below, I want to post the formula in cell A9 to get the number of duplicates...it should be 3. Thanks in advance!!! A B 1 4563 1231 2 1231 1551 3 6598 4563 4 2681 2681 5 32648 165165 6 131 156 7 416516 12 8 9 3 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Total Number of Dups in 2 columns
Already answered -- Don Guillett Microsoft MVP Excel SalesAid Software "Not Excelerated" wrote in message ... Hello! I have two sets of data in Columns A and B. I want to find out the total number of duplicate between columns A and B. I just want the know the total number of duplicates without copying down in another column. In the example below, I want to post the formula in cell A9 to get the number of duplicates...it should be 3. Thanks in advance!!! A B 1 4563 1231 2 1231 1551 3 6598 4563 4 2681 2681 5 32648 165165 6 131 156 7 416516 12 8 9 3 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count Dups in Two Columns | Excel Worksheet Functions | |||
| Comparing two columns for dups | Excel Discussion (Misc queries) | |||
| Total column changes colors when total equals sum of other columns | New Users to Excel | |||
| highlight dups in one of two columns | Excel Worksheet Functions | |||
| How can I use dcount to total the number of columns with entries? | Excel Worksheet Functions | |||
![Not Excelerated[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
