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

List of Surnames by color coding
Started by Kim W, Aug 17 2014 08:36 AM
2 replies to this topic
#1
Posted 17 August 2014 - 08:36 AM
#2
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":
- 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.
- 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 RM7630 FTM2017 Ancestry.ca FamilySearch.org FindMyPast.com wiki, exploiting the database in special ways >>>
app, a bundle of RootsMagic utilities.
#3
Posted 17 August 2014 - 12:25 PM
Thanks Tom, Just finished used the custom report!