Microsoft Office Forums How to count living family members in a list

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-29-2019, 11:13 PM
Marcia's Avatar
Marcia Marcia is offline How to count living family members in a list Windows 7 32bit How to count living family members in a list Office 2013
Competent Performer
How to count living family members in a list
 
Join Date: May 2018
Location: Philippines
Posts: 208
Marcia is on a distinguished road
Default How to count living family members in a list


Hi everyone. Another related question in my genealogy project. Is there a quick way of counting the living direct descendant (bloodlines) in a list of family members? The members who have gone to the great beyond are marked with (+) after their names. Living spouses or partners of direct descendants are not included in the count. Thank you.
Attached Files
File Type: docm CountClan.docm (39.9 KB, 1 views)
Reply With Quote
  #2  
Old 06-30-2019, 11:39 AM
Eowyn Eowyn is offline How to count living family members in a list Mac OS X How to count living family members in a list Office 2016 for Mac
Novice
 
Join Date: Jun 2019
Location: New York
Posts: 10
Eowyn is on a distinguished road
Default

A possible approach (but may need more testing)

Paste the list into Excel (using SOURCE formatting to make sure everything stays in one column).
Use the COUNTIF function to count those entries with a particular bit of text.

In my example, all the names pasted in now lives in cells C8 through C47. The function looks at that range and only counts the ones where it begins with a one and a period (1.). The asterix at the end of the criteria indicates I don't care what follows the 1. The asterix is a wildcard. Notice I put the criteria in quotation marks

=COUNTIF(C8:C47,"1.*") <- Count those that start with 1.

Similarly =COUNTIF(C8:C47, "*(+)*") <-Count those that have (+) somewhere in the cell.

For spouses, you might COUNTIF "*married*), but I see you had at least one husband, so you might need COUNTIFS (notice the plural) which can check for multiple criteria -- for more help there, you might need to post over in the Excel area). You can then do a simple calculation to subtract one from the other.
Attached Files
File Type: xlsx COUNTCLAN.xlsx (9.6 KB, 1 views)
Reply With Quote
  #3  
Old 07-01-2019, 07:00 AM
Marcia's Avatar
Marcia Marcia is offline How to count living family members in a list Windows 7 32bit How to count living family members in a list Office 2013
Competent Performer
How to count living family members in a list
 
Join Date: May 2018
Location: Philippines
Posts: 208
Marcia is on a distinguished road
Default

Thank you Eowyn, I guess Excel with COUNTIF will do the job of returning the needed data.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Add members to new group frustratedagain Outlook 1 09-07-2018 09:54 PM
Restart count number list Slamzor Word VBA 1 07-24-2018 01:51 PM
Family tree hierarchy in PowerPoint: bugs/errors red X's in bulletpoint list delta9@gmail.com PowerPoint 1 11-28-2015 10:44 AM
How to count living family members in a list Have an alphbetical list need to count how many names start with A, B, C etc. cadonn Excel 9 09-02-2014 02:06 PM
How to count living family members in a list identify non-members from two lists rterrain03 Office 5 12-01-2011 01:41 PM


All times are GMT -7. The time now is 09:08 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft