hello,
I am trying to create application that count ID number based on different services, the idea is to count the ID for each service but without duplicate if they were under same project otherwise count all IDs, also if the ID have 2nd round in different project to count it as new ID example below:
ID |
project |
type of service |
first round |
second round |
1 |
AA |
C |
yes |
|
1 |
BB |
N |
|
yes |
2 |
BB |
C |
yes |
yes |
3 |
BB |
C |
yes |
|
4 |
AA |
C |
yes |
yes |
5 |
AA |
C |
yes |
|
6 |
BB |
N |
|
|
6 |
BB |
C |
yes |
yes |
7 |
AA |
N |
|
|
8 |
AA |
N |
|
|
9 |
BB |
N |
yes |
|
10 |
AA |
C |
yes |
|
10 |
AA |
N |
|
yes |
any idea about how the formula will be?