Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cross Reference 2 columns in seperate workbooks
Hi, I am trying to determine if I can cross reference 2 columns in seperate
workbooks looking for duplicates. The workbooks are not identical. Work book 1 would be column A Worbook 2 would be column B I would like to delete the rows in Workbook 2 if the data in the 2 columns in both workbooks match. Any ideas? Pcakes |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cross Reference 2 columns in seperate workbooks
In workbook 2, create a 'helper' column and put a vlookup function something
like... =VLOOKUP(B2,[My1stWorkbook.xls]MySheet1!$A:$A,1,FALSE) if the formula does NOT return an '#N/A', delete it as it found a match in workbook 1. -- HTH, Gary Brown If this post was helpful to you, please select ''YES'' at the bottom of the post. "Pcakes" wrote: Hi, I am trying to determine if I can cross reference 2 columns in seperate workbooks looking for duplicates. The workbooks are not identical. Work book 1 would be column A Worbook 2 would be column B I would like to delete the rows in Workbook 2 if the data in the 2 columns in both workbooks match. Any ideas? Pcakes |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cross Reference 2 columns in seperate workbooks
First determine if each row is matching:
=countif(Book1!A$1:A$1000,B1) If this returns 1 you have a match. If you are using 2002+ you can then highlight the countif column and press Ctrl F and enter 1 and set it to search for values and then choose Find All. Select all the results in the bottom pane and close the Find box. Press Ctrl - (minus) and choose entire row (assuming that will work for you). If you are using an earlier version let us know. -- Thanks, Shane Devenshire "Pcakes" wrote: Hi, I am trying to determine if I can cross reference 2 columns in seperate workbooks looking for duplicates. The workbooks are not identical. Work book 1 would be column A Worbook 2 would be column B I would like to delete the rows in Workbook 2 if the data in the 2 columns in both workbooks match. Any ideas? Pcakes |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Delete columns simultaneously in several different workbooks | Excel Discussion (Misc queries) | |||
Adding Text from seperate columns | Excel Worksheet Functions | |||
how can I cross reference 1 excel spreadsheet against another | Excel Discussion (Misc queries) | |||
How do you cross reference different speadsheets? | Excel Discussion (Misc queries) | |||
Incrementing rows (or columns) to a reference in another worksheet | Excel Worksheet Functions |