Hello,
Looking to calculate age ranges of people in an excel list, but it should only count the non-duplicated names. So for the example below, it should only count "Same Person" and "Other Same Person" once so that it does not give me a false record of people in that age range.
I would like to accomplish this with a formula and not a pivot table, and no helping columns/calculations. I've tried using some variations of sumproduct and countif, but to no avail.
<tbody>
</tbody>
Looking to calculate age ranges of people in an excel list, but it should only count the non-duplicated names. So for the example below, it should only count "Same Person" and "Other Same Person" once so that it does not give me a false record of people in that age range.
I would like to accomplish this with a formula and not a pivot table, and no helping columns/calculations. I've tried using some variations of sumproduct and countif, but to no avail.
Name | Age | Age Range | Count | |
Same Person | 75 | 20-30 | 3 | |
Other Same Person | 20 | 31-40 | 0 | |
Same Person | 75 | 41-50 | 2 | |
Same Person | 75 | 51-60 | 0 | |
John Doe | 50 | 61+ | 1 | |
Elaine Smith | 23 | |||
Wendy Troupe | 50 | |||
Levi Smith | 25 | |||
Other Same Person | 20 |
<tbody>
</tbody>
Last edited: