To the best of my knowledge, it's always the second row. Ann On Fri, Dec 11, 2015 at 8:43 AM, Jim Bartlett <jim4bartletts@verizon.net> wrote: > 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 > > > > >

Ann, Thanks - very helpful. I'll try it on a copy of my spreadsheet. Jim - www.segmentology.org > On Dec 11, 2015, at 2:49 PM, Ann Turner <dnacousins@gmail.com> wrote: > > To the best of my knowledge, it's always the second row. > > Ann > >> On Fri, Dec 11, 2015 at 8:43 AM, Jim Bartlett <jim4bartletts@verizon.net> wrote: >> 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 >> > >> > >