Comparing and matching data of two columns not of the same size (countif?)

  • Thread starter Thread starter Londonderry
  • Start date Start date
L

Londonderry

I have two spreadsheets. One sheet has around 1060 rows, the other ha
18000 or so.

In column M of sheet 1, i need to find out which strings of number
match up with those also in sheet 2 column B.

I was thinking the best way to do this would be a countif statement
but I have only used that on single columns before. How do you do
countif with multiple columns
 
Hi
enter the following in N1
=IF(COUNTIF('sheet2'!$B:$B,M1)>0,"Match","No match")
and copy down
 
Perhaps --

=IF(ISNUMBER(MATCH(M1,'Sheet 2'!B:B,0)),"Match Found","No Match"
 
thanks for the help guys, that works awsome and saved me several hour
worth
 
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

CountIf with And 0
countif comparing two columns 4
Match and delete rows on two different sheets from reference numbers 4
countif only when an exact match occurs 5
Compare identifier columns from 2 sheets - remove rows that are dups 2
Finding the weighted average of text that have been given values 1
Excel 2007: complex COUNTIFS() 16
Opposite of Countifs 2

Back
Top