I have two different spreadsheets both contains names of companies, both may
contain same companies names. I want to find the same company names in both
work sheets.....

This can be a real problem Melanie. If the two lists were made by different
folks, or even the same person at different times, the "same" companies may
be spelled differently, or have different punctuation, such as Co or Co. or
INC...etc etc........one thing you might can do is to copy and paste both
lists into one, and then sort on the address column(s) if any, or ZIP code
or something like that to sorta group similar named companies
together.........then go through and delete by hand..........

hth
Vaya con Dios,
Chuck, CABGx3



"Melanie" wrote in message
...
I have two different spreadsheets both contains names of companies, both
may
contain same companies names. I want to find the same company names in
both
work sheets.....

=IF(ISERR(SMALL(IF(COUNTIF(Sheet2!$A$2:$A$300,Shee t1!$A$2:$A$300)<0,ROW(INDIRECT("1:"&ROWS(Sheet1!$ A$2:$A$300)))),ROWS($1:1))),"",INDEX($A$2:$A$300,S MALL(IF(COUNTIF(Sheet2!$A$2:$A$300,Sheet1!$A$2:$A$ 300)<0,ROW(INDIRECT("1:"&ROWS(Sheet1!$A$2:$A$300) ))),ROWS($1:1))))

Adjust your range to suit
ctrl+shift+enter, not just enter

"Melanie" wrote:

I have two different spreadsheets both contains names of companies, both may
contain same companies names. I want to find the same company names in both
work sheets.....