Forum Discussion
count how many time a value is in a column
I have list of names and a number near each name in a other column i want to know how many ppl i have from each number something like this 1 70 ppl 2 12 ppl 3 15 ppl any idea ?
| name | Rate |
| name a | 1 |
| name b | 1 |
| name c | 1 |
| name d | 1 |
| name e | 2 |
| name f | 2 |
I want to know how many ppl I have rate 1 how many 2 total numbers
| Rate | Total |
| 1 | 4 |
| 2 | 2 |
=
As variant for
formula is
=CHOOSE({1,2},UNIQUE($C$3:$C$8),COUNTIF($C$3:$C$8,UNIQUE($C$3:$C$8)))