Hello,
I have a spreadsheet where column A represents a person (1-242) and column B represent a choice that person made (1-5). Each person in column A gets to make 12 choices (i.e. there are 12*242=2904 rows). I would like a formula that counts the number of unique choices each person makes. In the example below the unique count for person 1 would be 4, the unique count for person 2 would be 3.... etc.
Thanks in advance for any assistance.
<tbody>
</tbody>
I have a spreadsheet where column A represents a person (1-242) and column B represent a choice that person made (1-5). Each person in column A gets to make 12 choices (i.e. there are 12*242=2904 rows). I would like a formula that counts the number of unique choices each person makes. In the example below the unique count for person 1 would be 4, the unique count for person 2 would be 3.... etc.
Thanks in advance for any assistance.
Person | Choice | |
1 | 1 | |
1 | 1 | |
1 | 2 | |
1 | 2 | |
1 | 2 | |
1 | 3 | |
1 | 3 | |
1 | 3 | |
1 | 3 | |
1 | 4 | |
1 | 4 | |
1 | 4 | |
2 | 1 | |
2 | 1 | |
2 | 1 | |
2 | 2 | |
2 | 2 | |
2 | 2 | |
2 | 2 | |
2 | 3 | |
2 | 3 | |
2 | 3 | |
2 | 3 | |
2 | 3 | |
3 | 1 | |
3 | 1 | |
3 | 2 |
<tbody>
</tbody>