Search for persons with no descendents
Posted 05 March 2009 - 04:14 PM
Posted 05 March 2009 - 09:04 PM
There is a way to get a list of people with their linked children that include people with no children.
Go to Reports>List>Individual list and select "Children of each person". Deselect the other choices.
Anyone with just their name with no children listed
Since we get people with children with this report, I would pick out the people with no children and add a user defined fact to each person's record.
I would come up with criteria of who to add the fact to, like not to a child who died young or people I know are a dead end, or people who already have my user defined fact that tells me they never had children.
Then when I wanted a report, I would just print a report for the user defined fact. rather than go through the long Individual report again.
Posted 06 March 2009 - 03:21 AM
1. Reports > Individual list > select showing children, deselect other, (top selector set to everyone in database)
2. Set Print to...to Text file
3. Print report to text file, name and save file
4. With text file open, select all text in file, and copy (Ctrl+C)
5. Open a blank spreadsheet in Excel:
5.a. paste into C1 cell of Sheet 1 (Ctrl+V...will paste automatically to other rows and columns as needed)
5.b. paste into C1 cell of Sheet 2 (Ctrl+V...just a raw backup in case anything goes wrong, so you don't have to repeat the copy-paste later)
6. Create formulas to extract needed data with:
6.a. In blank column B, type the following formula: =IF(C2="","",C1)
6.b. In blank column A, type the following formula: =IF(B1<>"",IF(b1=0,"",B1),B1)
6.c. Highlight cells A1 and B1, and copy (Ctrl+C)
6.d. Highlight cells A2 and B2, press and hold the Shift key...and while holding the Shift key, arrow, page or scroll down the the last row with data, and release Shift key (you should now have a long highlighted pair of columns (A & ...paste (Ctrl+V) - this will copy the A1 & B1 formulas to all rows of your data
At this point, column A should show only the names of those persons in column C who have no children. Now to get rid of the rest...
7. Highlight the entire spreadsheet with formulas (small square at top left...above row 1 label and left of column A label)...and copy (Ctrl+C)
8. Remove formulas:
8.a. Click into cell A1 of blank Sheet 3
8.b. Do NOT paste with Ctrl C...select Paste Special from Edit menu
8.c. Select Values in top portion of Paste Special dialog...click OK (data only without formulas will be pasted...otherwise the formulas will go crazy when you sort)
9. Get rid of unneeded data: highlight a few entire columns to the right of column A - col B, C, D, etc. and delete all data from them...leaving only col A with the names you want
10. Separate the data rows from the non-data rows: highlight the entire column A and use ascending sort (the non-data rows will be at the top)...then delete all blank rows above your data.
What you have now is a single column with the names of the people who have no children, including their individual number. If desired, you can copy paste groups of these names into several columns until you have all your names available without a 1000-mile-long single column list. SAVE - Then print it out.
I know it's a bit much, but it works very well, and doesn't really take all that long. When typing in the formulas, include all characters as given, such as equal sign at beginning, sets of double quotes with nothing between them, etc.
[example: "","" is dbl-quote dbl-quote comma dbl-quote dlb-quote]
With perseverence, this could be done with one formula column...but this worked now without taking excess brainpower to create.
Posted 07 March 2009 - 03:53 PM
In the mean time, what I did was go to:
Children of each person
selected - choose people
select people by data fields
surname = ****
sex = m
(**** = the surname of the family tree branch I am working on)
By this process I was able to narrow the list down considerably. Too bad RM doesn't have search criteria for 'age' or 'marital status', etc....I guess that will have to be the subject of a wish list item
Posted 08 March 2009 - 04:26 AM
Too bad RM doesn't have search criteria for 'age' or 'marital status', etc....I guess that will have to be the subject of a wish list item
You can go to Reports>Lists>Fact list and do a report for the Marriage fact.
Select People with this fact type, People without this fact type or People with more than one of this fact type.
An age search is included in Rm4.
Posted 09 March 2009 - 11:22 AM
Doug, the spreadsheet worked great once I loaded the formulas into Excel. I am going to keep the spreadsheet as a template and copy future branches of the family into the 'C' column.