Essentially this is what I am looking to do:
I have a spreadsheet with names, location, ethnicity, affiliation
I need create a column that will first find all of the entries with the same location and ethnicity(hereafter referred to as "group"), then count how of those entries are affiliated.
There may be a better order of operations for this equation. The end result should be displayed as one similar number (1,2,...) entered in the new column for each group. So if there are 10 people from town X, who are the same ethnicity, and only 2 have a party affiliation, then the formula will produce the number 2 for all 10 people in the group.
Bookmarks