how to compare data in two different work sheets
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..... |
how to compare data in two different 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..... |
how to compare data in two different 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..... |
All times are GMT +1. The time now is 10:42 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com