Jim It depends on where you insert the new rows and if you have done any other sorting of the merged file before you apply the function to check for duplicates. (I add an extra column in which I insert a date to use as a reference and sorting tool.) RPaine -----Original Message----- From: Jim Bartlett via Sent: Friday, December 11, 2015 8:43 AM To: Ann Turner ; genealogy-dna@rootsweb.com Subject: Re: [DNA] new cousins 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 > > ------------------------------- To unsubscribe from the list, please send an email to GENEALOGY-DNA-request@rootsweb.com with the word 'unsubscribe' without the quotes in the subject and the body of the message

Robert I, too, have a column for sorting and finding new rows added to my spreadsheet at the bottom. But sometimes a sort on name doesn't always leave the new ones on the bottom (and I have rows with same Match name for each segment). So I'm just interested in winding up with new rows which I can append to the master spreadsheet. Yours is a good tip. Jim - www.segmentology.org > On Dec 11, 2015, at 3:31 PM, Robert Paine <rpaine@vom.com> wrote: > > Jim > It depends on where you insert the new rows and if you have done any other sorting of the merged file before you apply the function to check for duplicates. (I add an extra column in which I insert a date to use as a reference and sorting tool.) > > RPaine > > -----Original Message----- From: Jim Bartlett via > Sent: Friday, December 11, 2015 8:43 AM > To: Ann Turner ; genealogy-dna@rootsweb.com > Subject: Re: [DNA] new cousins > > 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 > >