Find Missing Records "Chirag Dedhia" <chiragdedhia[ at ]gmail.com> 30.08.2006 10:04:44 I searched enough on this topic but couldn't find anything that i could put to use. Hence this query to you all. I have two excel sheets. Both Sheets have two columns (Name, Email Address) Now i need to find out if there is any record(row) missing in the first sheet by checking the second sheet, such that i can create a third sheet with all the missing records(rows). Any help or macros that you guys have used earlier, would be of great help to me. Regards, Chirag Dedhia

Re: Find Missing Records "GerryGerry" <Gerry[ at ]Gerry.anon> 30.08.2006 12:00:19 Try using a Vlookup on the second sheet using the first sheet as the table. Then filter all the #N/A and copy to the third sheet. "Chirag Dedhia" <chiragdedhia[ at ]gmail.com> wrote in message news:1156932284.686639.93780[ at ]74g2000cwt.googlegroups.com... [Quoted Text] > I searched enough on this topic but couldn't find anything that i could > put to use. Hence this query to you all. > > I have two excel sheets. > Both Sheets have two columns (Name, Email Address) > Now i need to find out if there is any record(row) missing in the first > sheet by checking the second sheet, such that i can create a third > sheet with all the missing records(rows). > > Any help or macros that you guys have used earlier, would be of great > help to me. > > Regards, > Chirag Dedhia >

Re: Find Missing Records Dave Peterson <petersod[ at ]verizonXSPAM.net> 30.08.2006 12:03:30 Can you use the email addresses to look for matches? If yes, then you can add a column of formulas to sheet2 that returns true or false depending on if that email address appears in sheet1. Say the email addresses are in column C of both sheets. Insert a new column D in sheet2 and put this formula in D1: =isnumber(match(c1,sheet1!c:c,0)) and drag down. The cells that are true show that the email address appears in Sheet1. The cells with False don't appear in sheet1. You could filter by this column. Show the Falses and copy those visible rows to a new sheet. Chirag Dedhia wrote: [Quoted Text] > > I searched enough on this topic but couldn't find anything that i could > put to use. Hence this query to you all. > > I have two excel sheets. > Both Sheets have two columns (Name, Email Address) > Now i need to find out if there is any record(row) missing in the first > sheet by checking the second sheet, such that i can create a third > sheet with all the missing records(rows). > > Any help or macros that you guys have used earlier, would be of great > help to me. > > Regards, > Chirag Dedhia -- Dave Peterson

Re: Find Missing Records "Chirag Dedhia" <chiragdedhia[ at ]gmail.com> 31.08.2006 10:46:48 Amazing!! Thnx so much!! Dave Peterson wrote: [Quoted Text] > Can you use the email addresses to look for matches? > > If yes, then you can add a column of formulas to sheet2 that returns true or > false depending on if that email address appears in sheet1. > > Say the email addresses are in column C of both sheets. > > Insert a new column D in sheet2 and put this formula in D1: > =isnumber(match(c1,sheet1!c:c,0)) > and drag down. > > The cells that are true show that the email address appears in Sheet1. The > cells with False don't appear in sheet1. > > You could filter by this column. > Show the Falses > and copy those visible rows to a new sheet.