| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Exact rows, multiple sheets
I need to compare two sheets one workbook. I need to know which rows are the same in Sheets1 and Sheets2 with 14 columns of information to compare? There are about 8000 rows in each sheet. -- jcohen029 ------------------------------------------------------------------------ jcohen029's Profile: http://www.excelforum.com/member.php...o&userid=24062 View this thread: http://www.excelforum.com/showthread...hreadid=376683 |
|
#2
|
|||
|
|||
|
In sheet3, simply enter =IF(Sheet1!A1=Sheet2!A1,Sheet1!A1=Sheet2!A1,"") or =IF(Sheet1!A1=Sheet2!A1,Sheet1!A1,"") and copy to the lenght and breadth of sheet1 This will put TRUE when there is a match, and a blank otherwise. The second formula puts the actual value instead of a TRUE. Mangesh -- mangesh_yadav ------------------------------------------------------------------------ mangesh_yadav's Profile: http://www.excelforum.com/member.php...o&userid=10470 View this thread: http://www.excelforum.com/showthread...hreadid=376683 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying multiple sheets from one book 2 another and undertake spec | Excel Discussion (Misc queries) | |||
| Multiple sheets selected | Excel Discussion (Misc queries) | |||
| linking multiple sheets to a summary sheet | Excel Discussion (Misc queries) | |||
| Need Function for adding rows on multiple sheets... struggling rookie ;) Thanks. | Excel Worksheet Functions | |||
| Identifying exact values in alternate rows | Excel Worksheet Functions | |||
Linear Mode
