Hi all
I am trying to count unique text occurences for some customers. As my data sheet includes some #N/A in the cells of the customers (and contract types), I need a formula that takes into account. The current formula does not seem to care if the contract type is #N/A, but I cannot fix it when the #N/A is in the customer column.
Is there any genius in this forum who knows how to solve it?
<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
<tbody>
</tbody>
I am trying to count unique text occurences for some customers. As my data sheet includes some #N/A in the cells of the customers (and contract types), I need a formula that takes into account. The current formula does not seem to care if the contract type is #N/A, but I cannot fix it when the #N/A is in the customer column.
Is there any genius in this forum who knows how to solve it?
D | E | F | G | H | I | |
---|---|---|---|---|---|---|
6 | Customer | Contract type | Customer | Uniqe contract count | ||
7 | 1 | A | 1 | 2 | ||
8 | 2 | B | 2 | |||
9 | 1 | A | 3 | |||
10 | 1 | 4 | ||||
11 | 1 | C | ||||
12 | 2 | A | ||||
13 | 3 | B | ||||
14 | 3 | B | ||||
15 | 2 |
<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
Unique contract count
Array Formulas
<thead> </thead><tbody> </tbody> Note: Do not try and enter the {} manually yourself |
<tbody>
</tbody>