Total Number of Dups in 2 columns

N

Not Excelerated

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count Dups in Two Columns 6
Add a sequence number(question number) to a paragraph which has a question and 4 options and answer 0
Compare identifier columns from 2 sheets - remove rows that are dups 2
Help with multi-level list 0
Change a great number of words in word files, with a macro as short as possible. 5
Make elements in a row space between instead of wrapping when choosing multiple columns 0
Adding sequence numbers to paragraphs 0
Formating bolded text exclusively. 0

Top