Jump to content


Photo

List of Surnames by color coding


  • Please log in to reply
2 replies to this topic

#1 Kim W

Kim W

    Advanced Member

  • Members
  • PipPipPip
  • 186 posts

Posted 17 August 2014 - 08:36 AM

Is there a way to get a list of surnames by their color code?



#2 TomH

TomH

    Advanced Member

  • Members
  • PipPipPip
  • 6267 posts

Posted 17 August 2014 - 09:26 AM

Not directly, if you want just one row per unique surname. I can think of two methods, both based on creating a named group on the color-coding, let's say it is named "Red":

  1. Create a custom report with just one field, Surname. In the "People to include" setting, choose "Red" and Generate report. This will have the same surname repeated for every individual in the Red group having that surname. So, save the report to a text file. Open it with a spreadsheet application and use formulas to flag duplicates and then filter the list to show only the unique ones.
  2. Export to GEDCOM, selecting "Red" in the "People to export" list. Import to a new database and run the report, Lists > Surname Statistics List which will give you just the unique surnames along with other columns of info you may or may not want. You can edit the columns out by saving the report to text or to RTF. Alternatively, you could create the custom report as in #1 and process it the same way.

Edited by TomH, 17 August 2014 - 09:27 AM.

Tom user of RM7550 FTM2017 Ancestry.ca FamilySearch.org FindMyPast.com
SQLite_Tools_For_Roots_Magic_in_PR_Celti wiki, exploiting the database in special ways >>> RMtrix-tiny.png app, a bundle of RootsMagic utilities.


#3 Kim W

Kim W

    Advanced Member

  • Members
  • PipPipPip
  • 186 posts

Posted 17 August 2014 - 12:25 PM

Thanks Tom, Just finished used the custom report!