I've tried using various count formulas but have been unable to get this to work the way I would like. I'm running Excel 2007. If you need more specifics let me know. I appreciate any tips or advise on how to get this to work.
I need 4 things...
1. Compare Col A & Col B and count number of matches
2. Count number of duplicate records in Col A
3. Count number of duplicate records in Col B
4. Count number of records that have no match in Col A & Col B
Example: Col C would hold the results
C1 = Matches in Col A & B
C2 = Dups in Col A
C3 = Dups in Col B
C4 = No matches Col A
C5 = No matches Col B
<tbody>
</tbody>
I need 4 things...
1. Compare Col A & Col B and count number of matches
2. Count number of duplicate records in Col A
3. Count number of duplicate records in Col B
4. Count number of records that have no match in Col A & Col B
Example: Col C would hold the results
C1 = Matches in Col A & B
C2 = Dups in Col A
C3 = Dups in Col B
C4 = No matches Col A
C5 = No matches Col B
1 | 1 | 7 |
2 | 2 | 1 |
3 | 3 | 2 |
3 | 4 | 2 |
4 | 4 | 1 |
5 | 6 | |
7 | 7 | |
8 | 8 | |
9 | 10 | |
10 | 10 |
<tbody>
</tbody>