Hi Steve, Please find attached excel for solution to your query.
I have use conditional formatting to find duplicate values in the lists. Following is formula: =COUNTIF(D3:D18, B3)>=1 I have applied conditional formatting for list 1. If name is there in both the list then it will highlight that name in list 1. If you have any query then let me know. Regards, Swapnil. On Thu, Dec 17, 2009 at 1:14 PM, Steve <sca...@aol.com> wrote: > I have a few lists of names and dobs, each over 1,000 lines. I am > trying to find names and dob's that are common to two lists. The > names I want to pull out are the ones that are on each, if they are > only on one list I am not interested in them. > > What I've done so far is paste two lists together, sort by dob and > last name, and scroll down the list looking for duplicates. This is a > PITA when the lists, pasted together, exceed 3,000 lines. > > Can anyone steer me to a better way of getting this done? I will be > doing this routinely. There is one "master" list and I will be > comparing a few other lists to this master list looking for people > that appear on both. > > Thanks, > Steve > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at > http://www.excelitems.com > 2. Excel tutorials at http://www.excel-macros.blogspot.com > 3. Learn VBA Macros at http://www.vbamacros.blogspot.com > 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > > To post to this group, send email to excel-macros@googlegroups.com > If you find any spam message in the group, please send an email to: > Ayush Jain @ jainayus...@gmail.com or > Ashish Jain @ 26may.1...@gmail.com > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,500 subscribers worldwide and receive many nice notes about > the learning and support from the group. Our goal is to have 10,000 > subscribers by the end of 2009. Let friends and co-workers know they can > subscribe to group at > http://groups.google.com/group/excel-macros/subscribe -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Find Duplicate.xls
Description: MS-Excel spreadsheet
