MNCamper 0 Report post Posted October 30, 2006 I wish to create a list of my ancestor surnames. I thought this would be easy. I used the 'List of People' report with a filter of 'Ancestors of #3' (me). And then specified the output as the Surname field. This gave me a list of all my ancestor surnames, but I got duplicates for each occurance of an ancestor with the same surname. The only way that I see to get the list I want is to output this list to a file and then edit the file to eliminate the duplicates. This seems like a common report to want to run, so I am guessing that I am missing something. Any tips? Rick Share this post Link to post Share on other sites
Joanne Skelton 0 Report post Posted October 30, 2006 Try the Distribution of People report. It can be sorted either by frequency or column value (surname). Joanne Skelton Share this post Link to post Share on other sites
MNCamper 0 Report post Posted October 31, 2006 Thanks, Joanne. The Distribution report is not one that I am familiar with. I learned something new. This report gets rid of the duplicates. But it adds the columns for frequency and percent. I think it might be easier to edit out the duplicates from the list of people report. Rick Share this post Link to post Share on other sites