| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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..... |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Manual control of link updating for downloaded quotes? | Excel Discussion (Misc queries) | |||
| How to make userform work publically with hidden sheets? | Excel Discussion (Misc queries) | |||
| How to make userform work publically with hidden sheets? | Excel Worksheet Functions | |||
| macro | Excel Discussion (Misc queries) | |||
| Pie Diagram from data across multiple work sheets | Charts and Charting in Excel | |||
Threaded Mode
