This may be a bit tricky with your customized columns, but it seems like there should be a way to use Excel's tool to delete duplicate rows. You would append a fresh download to your master spreadsheet, lining up the columns to match your custom layout. Then tell Excel to delete duplicates based on the data in certain columns. Ann Turner On Fri, Sep 1, 2017 at 12:13 PM, Jim Bartlett <[email protected]> wrote: > Kuba > > I, too, would like to see an automatic updating program - from 23andMe or > some 3rd party. > > In the meantime..... > I download the whole DNA Relatives list; adjust to my master spreadsheet > format (including adding a color coded column to distinguish all of these > rows); append to my spreadsheet; sort the whole thing by 23andMe kits and > Name; then look down the whole 23andMe list adding a tick for each new row > (usually an all-nighter); then resort to delete all new rows except the > ticked new ones; then sort only the 23andMe rows by Chr and Start. This > puts all the new 23andMe Match-segments intermingled in the two potential > previously determined Triangulated Groups. All prior analysis is preserved. > Then a long slog to determine the correct TG (or side) for each new one. It > goes pretty fast because there is a link (included in the download) that > take you straight to the Match's page - just scroll down to the ICW list > and check the "Yes" Matches - they will all be in the TG on one side (none > on the other TG). Frequently this review includes some of the other new > segments - so include them new, easily, in the same TG. Often another long > evening - I do this at 23andMe about every 3 months with a few hundred new > segments. I have a standard message (one paternal, one maternal) with links > to my Tree, blog, and a list of Patriarch for that side. As long as I'm on > the Match's page, I paste that in to the adjacent message box. > > If 23andMe just included a date for each Match in the download > spreadsheet, it would cut my time considerably. > > If there is a more efficient way - I'd welcome it. > > Jim Bartlett - atDNA blog: www.segmentology.org > >