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.
|