Hi,
I have function to count how many many times name from column C (sheet M1) appear in range (sheet CSTG, column B):
<tbody>
</tbody>
Now in column Q (sheet CSTG) I have different values, like: 1, 1.0, 1.2, 2.0, 3.2 etc.
I need to count how many different values is for each name for column C.
<tbody>
</tbody>
What should I do?
I have function to count how many many times name from column C (sheet M1) appear in range (sheet CSTG, column B):
Code:
=COUNTIFS(CSTG!$B:$B,'M1'!C7)
Column C | Column D - only count |
Audi | 5 |
BMW | 7 |
VW | 10 |
Fiat | 3 |
<tbody>
</tbody>
Now in column Q (sheet CSTG) I have different values, like: 1, 1.0, 1.2, 2.0, 3.2 etc.
I need to count how many different values is for each name for column C.
Column C | Column D | Column E - diffrent version |
Audi | 3 | 2 |
BWM | 7 | 5 |
VW | 10 | 4 |
Fiat | 3 | 2 |
<tbody>
</tbody>
What should I do?