2 replies to this topic

[Kim W]

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

[TomH]

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.

[Kim W]

Thanks Tom, Just finished used the custom report!