Karen, Thanks very much - your hint to copy my 23andMe rows to a new spreadsheet is the key for me - thanks. I've played around with the delete duplicates process but was unwilling to try it on my Master spreadsheet. I'll give your method a try. I know what you mean about learning the keystrokes for a process. I imbed hyperlinks in text all the time - in Word docs and Excel. I can copy a URL to the clipboard; then highlight the text I want use for the hyperlink; and type: ALT-I-I; CNTR-V; Enter in pretty much one quick flurry. When I go back to my typed notes I can easily CNTR-click a link to see the census record or Tree or whatever other reference I had. Thanks again for sharing your skills, Jim Bartlett [email protected] -----Original Message----- From: Karen White <[email protected]> To: genealogy-dna <[email protected]> Sent: Fri, Sep 1, 2017 4:24 pm Subject: [DNA] Downloading new 23andMe matches Jim Bartlett wrote: > If there is a more efficient way - I'd welcome it. Here is what I do. It doesn't take long. (It might be possible to write a macro to do it for you, but I don't know how.) Copy all the match names & sources from the spreadsheet you already have, into a new spreadsheet. Sort by source, and delete the ones that aren't from 23andMe. Then delete the source column, leaving only the names. Download all the matches from 23andMe. Delete everyone that isn't sharing or open sharing. Copy the column with the match's name into a second column in the new spreadsheet. In the new spreadsheet: Delete all extraneous spaces. (Use Ctrl-F "Replace all" and replace double spaces with single spaces. Might have to do it twice to make sure you get them all.) Highlight the first column and remove all duplicates (Data --> Remove Duplicates). Highlight the second colum and remove all duplicates. Select both columns. Home --> Conditional Formatting --> Highlight Cells Rules --> Duplicate Values Once there, click "Unique" instead of "Duplicate", then select which type text & fill you want. I use Green Fill with Dark Green Text. This makes everything green that is not in both columns. You don't care what's green in the first column. Sort the second column on font color, with green at the top (or whatever color you chose earlier). Those green ones are the matches that aren't already in your spreadsheet. It's then easy to go to the whole list you downloaded, find the new ones, and copy them over to the new spreadsheet. Once you've done this a few times, you get the hang of it and can do it in 5 minutes or so. Karen

Dear Jim and others, I have a formula I use in Excel to find duplicates: =IF(ISERROR(MATCH(B2,$I$1:$I$5000,0)),"",B2). This formula is quite flexible and I use it relatively frequently in various situations. Tim Janzen -----Original Message----- From: GENEALOGY-DNA [mailto:[email protected]] On Behalf Of Jim Bartlett Sent: Friday, September 1, 2017 1:57 PM To: [email protected] Subject: Re: [DNA] Downloading new 23andMe matches Karen, Thanks very much - your hint to copy my 23andMe rows to a new spreadsheet is the key for me - thanks. I've played around with the delete duplicates process but was unwilling to try it on my Master spreadsheet. I'll give your method a try. Thanks again for sharing your skills, Jim Bartlett