Note: The Rootsweb Mailing Lists will be shut down on April 6, 2023. (More info)
RootsWeb.com Mailing Lists
Total: 1/1
    1. [DNA] Downloading new 23andMe matches
    2. Karen White
    3. 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

    09/01/2017 09:20:37