Odd. Worked perfectly for me. All I had to do to get the data I wanted was to sort by column B. See attached for a screenshot.
Gary On Wed, Jun 3, 2020 at 9:18 AM Roberta Schwalm <robertaschw...@gmail.com> wrote: > I tried using Excel as suggested by Brian Kelly (and others previously) > but it didn't work for me even if I am a long-time Excel user. > > Roberta Schwalm > > On Wed, Jun 3, 2020 at 8:22 AM Gary 'n Mic McFall <garyand...@gmail.com> > wrote: > >> Thanks for the follow up. I was able to get the counts I needed with the >> suggestion from Brian Kelly. I'm going to keep your suggestion, though, as >> it may come in handy for related needs. >> >> Gary >> >> On Tue, Jun 2, 2020 at 7:22 PM Roberta Schwalm <robertaschw...@gmail.com> >> wrote: >> >>> Let me know if it works for you. And if you have any questions, just >>> let me know. >>> >>> Roberta >>> >>> On Tue, Jun 2, 2020 at 5:47 PM Gary 'n Mic McFall <garyand...@gmail.com> >>> wrote: >>> >>>> Thanks for the idea/suggestion! >>>> >>>> Gary >>>> >>>> On Tue, Jun 2, 2020 at 3:28 PM Roberta Schwalm < >>>> robertaschw...@gmail.com> wrote: >>>> >>>>> Have you tried doing a descendants chart, starting with the couple? >>>>> >>>>> Select the couple with the 21 children and click on *Reports* and >>>>> select *Descendant Book* >>>>> >>>>> Click on *Options* and check at the bottom if the name of that couple >>>>> is there >>>>> >>>>> Under Options, select which Option you want (there are three and you >>>>> will have to go through all three). >>>>> >>>>> The next page you get will have the heading "Descendant Book >>>>> Options". You will have a choice of 7 tabs: *Options*, *Page Layout*, >>>>> *Heading Layout*, *Wording 1 *and *Wording 2*. You will need to go >>>>> through all of them in turn: >>>>> >>>>> Under *Options* and check the features that you want to appear. >>>>> >>>>> Under *Page Layout*, select what you want. >>>>> >>>>> Under *Heading Layout,* ensure that the couple's name appears in the >>>>> first box and "Descendants of so and so" appears in the second box. I >>>>> have >>>>> checked "Both" under Generation Subtitles Labels. >>>>> >>>>> I left "Wording 1" and "Wording 2" as is. >>>>> >>>>> Under *Index Options*, I have the following checked: Name List; >>>>> Include a name, Birth and Death years on name; Include alternate names >>>>> (aliases and nicknames as, in my case, most of my relatives and friends >>>>> are >>>>> more familiar with my nickname),:Style 1 with bold box checked; Upper case >>>>> Surnames and One Column are both checked. I didn't select anything in >>>>> Location Index. >>>>> >>>>> Under *Report Options*, you have five options: *Include*, *Format*, >>>>> *Notes/Stories*, *Sources* and *Pictures*. Again, you will need to >>>>> go through each one in turn and select whatever you want. The only one >>>>> where I have made changes is under Format where I have "Don't repeat >>>>> duplicate lines" and "Highlight direct-line children" checked. >>>>> >>>>> As for the *Title Page*, enter "Descendants of" in the first box and >>>>> "the couples' names" in the second box and click on *Save.* >>>>> >>>>> Once you have clicked on Save, you will be brought back to the >>>>> "Descendant Book Report Options" where you will be able to preview your >>>>> report. >>>>> >>>>> You can select different formats if you wish to give/email the >>>>> report. These are "*Text File*, *HTML File*, *Rich Text File* or *PDF >>>>> File*". My personal preference is PDF File. >>>>> >>>>> I hope this helps. >>>>> >>>>> Roberta Schwalm >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> On Tue, Jun 2, 2020 at 12:01 PM Gary 'n Mic McFall < >>>>> garyand...@gmail.com> wrote: >>>>> >>>>>> Good morning. My wife's father was one of 21 children from the same >>>>>> parents. One of the family has asked how many grandchildren, etc., that >>>>>> union has. I looked, but can't find, a report option that will provide >>>>>> the >>>>>> number of descendants by relationship (child, grandchild, etc.) for a >>>>>> husband/wife. Is there such a thing available? >>>>>> >>>>>> Thanks in advance . . . >>>>>> >>>>>> Gary McFall >>>>>> >>>>>> -- >>>>>> No trees were harmed by sending this message, however a few million >>>>>> electrons may have been slightly inconvenienced. >>>>>> -- >>>>>> >>>>>> LegacyUserGroup mailing list >>>>>> LegacyUserGroup@legacyusers.com >>>>>> To manage your subscription and unsubscribe >>>>>> http://legacyusers.com/mailman/listinfo/legacyusergroup_legacyusers.com >>>>>> Archives at: >>>>>> http://www.mail-archive.com/legacyusergroup@legacyusers.com/ >>>>>> >>>>> -- >>>>> >>>>> LegacyUserGroup mailing list >>>>> LegacyUserGroup@legacyusers.com >>>>> To manage your subscription and unsubscribe >>>>> http://legacyusers.com/mailman/listinfo/legacyusergroup_legacyusers.com >>>>> Archives at: >>>>> http://www.mail-archive.com/legacyusergroup@legacyusers.com/ >>>>> >>>> >>>> >>>> -- >>>> No trees were harmed by sending this message, however a few million >>>> electrons may have been slightly inconvenienced. >>>> -- >>>> >>>> LegacyUserGroup mailing list >>>> LegacyUserGroup@legacyusers.com >>>> To manage your subscription and unsubscribe >>>> http://legacyusers.com/mailman/listinfo/legacyusergroup_legacyusers.com >>>> Archives at: >>>> http://www.mail-archive.com/legacyusergroup@legacyusers.com/ >>>> >>> -- >>> >>> LegacyUserGroup mailing list >>> LegacyUserGroup@legacyusers.com >>> To manage your subscription and unsubscribe >>> http://legacyusers.com/mailman/listinfo/legacyusergroup_legacyusers.com >>> Archives at: >>> http://www.mail-archive.com/legacyusergroup@legacyusers.com/ >>> >> >> >> -- >> No trees were harmed by sending this message, however a few million >> electrons may have been slightly inconvenienced. >> -- >> >> LegacyUserGroup mailing list >> LegacyUserGroup@legacyusers.com >> To manage your subscription and unsubscribe >> http://legacyusers.com/mailman/listinfo/legacyusergroup_legacyusers.com >> Archives at: >> http://www.mail-archive.com/legacyusergroup@legacyusers.com/ >> > -- > > LegacyUserGroup mailing list > LegacyUserGroup@legacyusers.com > To manage your subscription and unsubscribe > http://legacyusers.com/mailman/listinfo/legacyusergroup_legacyusers.com > Archives at: > http://www.mail-archive.com/legacyusergroup@legacyusers.com/ > -- No trees were harmed by sending this message, however a few million electrons may have been slightly inconvenienced.
-- LegacyUserGroup mailing list LegacyUserGroup@legacyusers.com To manage your subscription and unsubscribe http://legacyusers.com/mailman/listinfo/legacyusergroup_legacyusers.com Archives at: http://www.mail-archive.com/legacyusergroup@legacyusers.com/