| AGE | CARD | SCORE |
|---|---|---|
| 10 | 1 | 20000 |
| 10 | 1 | 3000 |
| 25 | 0 | 2000 |
| 10 | 1 | 20000 |
| 18 | 1 | 3000 |
| 10 | 0 | 2000 |
| 12 | 1 | 20000 |
| 10 | 1 | 3000 |
| 10 | 0 | 2000 |
I want to count Age 10 as 4.
The first two rows (group) should be counted as 1 and 10 appearing in different rows can be added individually and the last two rows (group of age 10) should be counted as 1.
CodePudding user response：
Assuming that data is in a table named "Table1":
=COUNT(1/FREQUENCY(IF(Table1[AGE]=10,ROW(Table1[AGE])),IF(Table1[AGE]<>10,ROW(Table1[AGE]))))