Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
cross referencing 2 workbooks at same time
I have one workbook which lists email addresses. Book 1
I have another workbook which lists the email addresses from Book 1 which are bad. Book 2 I now want to take out of Book 1 the bad email address but do not want to do it manually (as over 4000 bad email addresses) Any ideas please????? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
cross referencing 2 workbooks at same time
Hi GezCam,
I am lost here, could you give an example, how do you know are bad email addresses "GezCam" wrote: I have one workbook which lists email addresses. Book 1 I have another workbook which lists the email addresses from Book 1 which are bad. Book 2 I now want to take out of Book 1 the bad email address but do not want to do it manually (as over 4000 bad email addresses) Any ideas please????? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
cross referencing 2 workbooks at same time
Write a formula in Book1 that finds missing in book2
=ISNUMBER(MATCH(G1,'[Book2.xls]June 08'!$A:$A,0)) Then filter on that formula column looking for TRUE, and delete all visible rows. -- __________________________________ HTH Bob "GezCam" wrote in message ... I have one workbook which lists email addresses. Book 1 I have another workbook which lists the email addresses from Book 1 which are bad. Book 2 I now want to take out of Book 1 the bad email address but do not want to do it manually (as over 4000 bad email addresses) Any ideas please????? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
cross referencing 2 workbooks at same time
Hi,
How is your data set up - are there columns for First Name, Last Name, Street, City, State, Zip? Do you have a unique identifer, for example a social security number or employee ID? Let's suppose column A in both worksheets contains customer ID. Then in Book 1 create the following formula in a blank column. =VLOOKUP(A1,[Book2]Sheet1!A$1:A$6000,1,FALSE) If A1 is found in the list of bad addresses this formula will return the customer ID, otherwise it will return an NA error. Select all of these formulas and press F5, Special, Formulas and uncheck errors, click OK. Press Ctrl+- (control minus) and choose Entire Row. If this helps, please click the Yes button Cheers, Shane DEvenshire "GezCam" wrote: I have one workbook which lists email addresses. Book 1 I have another workbook which lists the email addresses from Book 1 which are bad. Book 2 I now want to take out of Book 1 the bad email address but do not want to do it manually (as over 4000 bad email addresses) Any ideas please????? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
cross referencing | Excel Worksheet Functions | |||
Cross referencing | Excel Worksheet Functions | |||
Cross Referencing | Excel Discussion (Misc queries) | |||
Cross referencing data across different workbooks | Excel Discussion (Misc queries) | |||
cross referencing | Excel Worksheet Functions |