Help needed!
Data below shown John has 3 outlets in Jan. What would be the formula for me to put in C3 to get 3? If I change the manager to Smith, will the number change automatically as well? Thanks!
<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>
Data below shown John has 3 outlets in Jan. What would be the formula for me to put in C3 to get 3? If I change the manager to Smith, will the number change automatically as well? Thanks!
A | B | C | D | |
1 | Month | Jan | ||
2 | Manager | John | ||
3 | No of Shop | 3 | (Exclude duplicate) | |
4 | ||||
5 | Month | Manager | Shop | Staff |
6 | Jan | John | AAA | A |
7 | Jan | John | AAA | B |
8 | Jan | John | BBB | C |
9 | Jan | John | CCC | D |
10 | Jan | John | AAA | E |
11 | Jan | Smith | YYY | F |
12 | Jan | Smith | ZZZ | G |
13 | Jan | Smith | XXX | H |
14 | Jan | Smith | XXX | I |
15 | Jan | Smith | WWW | J |
16 | Jan | Smith | ZZZ | K |
17 | Jan | Smith | YYY | L |
18 | Jan | Smith | WWW | M |
19 | Feb | John | AAA | N |
20 | Feb | John | AAA | O |
21 | Feb | John | AAA | P |
22 | Feb | John | AAA | Q |
23 | Feb | John | AAA | R |
24 | Feb | John | AAA | S |
<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>