Ann As I look at this, I'd tweak your process a little. I use a lot of color in my spreadsheet (pink and blue for sides; brown for IBS; yellow for Matches at two companies; green to highlight HLA, Neanderthal, etc. regions). So I color code (purple) a column in the fresh download and look for them at the bottom after the delete-dups process. Also I do this on a copy of my spreadsheet, just to quickly cull out the new new Matches. I'd then copy only those to my master spreadsheet. Maybe a few extra steps, but I'd be nervous running any kind of delete-some-of-the-rows program on my master spreadsheet. Jim - www.segmentology.org > On Dec 10, 2015, at 9:53 AM, Jim Bartlett via <genealogy-dna@rootsweb.com> wrote: > > This is a great plan, Ann. I've been requesting the aggregated list about weekly. In the past I appended it to my spreadsheet about every 6 months, sorted by name and compared all by hand. there were always ones I had missed, somehow, and there was a small percentage with "shifted" values - but never enough to change which Triangulated Group they were in, so I don't worry about that now. > > Using your method to easily just sort out the new Matches will be a big time saver. > > Jim - www.segmentology.org > >> On Dec 10, 2015, at 6:27 AM, Ann Turner via <genealogy-dna@rootsweb.com> wrote: >> >> Do you download your entire list from time to time? If so, you could open >> your most recent list in Excel and highlight all the cells with some color. >> Then download your current list and copy-and-paste it at the end of the >> recent list. Ask Excel to delete duplicates (in the Data ribbon in Excel >> 2012). New matches and rows where anything has changed would be at the >> bottom without any color coding. This would include changes in their list >> of ancestors and other editable fields, but you could probably eyeball >> those, or tweak which fields you include in the deletion phase. >> >> Ann Turner >

That works, too, and it's always safest to keep a copy of your master spreadsheet. However, any deletions occur in the appended lines. Also, and I suspect you've done this, but just to make it explicit for someone experimenting with this approach: if you add columns to your master spreadsheet with your personal notes, do not include those columns when you ask Excel to look for duplicate rows. Ann Turner On Fri, Dec 11, 2015 at 5:16 AM, Jim Bartlett <jim4bartletts@verizon.net> wrote: > Ann > > As I look at this, I'd tweak your process a little. > I use a lot of color in my spreadsheet (pink and blue for sides; brown for > IBS; yellow for Matches at two companies; green to highlight HLA, > Neanderthal, etc. regions). So I color code (purple) a column in the fresh > download and look for them at the bottom after the delete-dups process. > Also I do this on a copy of my spreadsheet, just to quickly cull out the > new new Matches. I'd then copy only those to my master spreadsheet. Maybe a > few extra steps, but I'd be nervous running any kind of > delete-some-of-the-rows program on my master spreadsheet. > > Jim - www.segmentology.org > > > On Dec 10, 2015, at 9:53 AM, Jim Bartlett via < > genealogy-dna@rootsweb.com> wrote: > > > > This is a great plan, Ann. I've been requesting the aggregated list > about weekly. In the past I appended it to my spreadsheet about every 6 > months, sorted by name and compared all by hand. there were always ones I > had missed, somehow, and there was a small percentage with "shifted" > values - but never enough to change which Triangulated Group they were in, > so I don't worry about that now. > > > > Using your method to easily just sort out the new Matches will be a big > time saver. > > > > Jim - www.segmentology.org > > > >> On Dec 10, 2015, at 6:27 AM, Ann Turner via <genealogy-dna@rootsweb.com> > wrote: > >> > >> Do you download your entire list from time to time? If so, you could > open > >> your most recent list in Excel and highlight all the cells with some > color. > >> Then download your current list and copy-and-paste it at the end of the > >> recent list. Ask Excel to delete duplicates (in the Data ribbon in Excel > >> 2012). New matches and rows where anything has changed would be at the > >> bottom without any color coding. This would include changes in their > list > >> of ancestors and other editable fields, but you could probably eyeball > >> those, or tweak which fields you include in the deletion phase. > >> > >> Ann Turner > > >

Ann Say you highlight the Match name and segment info (Chr, Start, End, cM, SNP)... Which duplicate row is deleted? Always the second row? I want to try this method, just need to know what happens. Jim - www.segmentology.org > On Dec 11, 2015, at 9:23 AM, Ann Turner via <genealogy-dna@rootsweb.com> wrote: > > That works, too, and it's always safest to keep a copy of your master > spreadsheet. However, any deletions occur in the appended lines. > > Also, and I suspect you've done this, but just to make it explicit for > someone experimenting with this approach: if you add columns to your master > spreadsheet with your personal notes, do not include those columns when you > ask Excel to look for duplicate rows. > > Ann Turner > >