Matching Data

  • Thread starter Thread starter mattmurr6218
  • Start date Start date
M

mattmurr6218

How do I take phone numbers from one column and then match them to another
column so i can see how many numbers are the same?
 
If you just want to identify those duplicated numbers (with a count) then
COUNTIF() can do it for you.

Assume the first column is A and the other column is C with rows used from 2
to 234,
in the first cell next to a phone number in column A put this formula
(assume it's on row 2), so this goes into B2:

=COUNTIF(A2,$C$2:$C$234)
and then fill that down in column B as far as your numbers in it goes. It
will give you a count of number of times each number in A appears in C.
 
Ack!! Can't believe I did that!! Turn the inside of that formula around - I
wrote it backwards, should have been:
=COUNTIF($C$2:$C$234,A2)
 
You must log in or register to reply here.

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

Index/match across multiple columns? 19
how do I excel 0
Matching records in two lists 2
VBA- IF statement to replace cell contents 0
Vlookup with Multiple Columns to Match 2
Auto sorting to match 1
Moving data from one column to another 5
Count Based on Comparison with Two Fields 2

Back
Top