Hi,
Sorry if there is another thread about this, but I can't find any, or I don't know the right search criteria
Please see below table.
Do you know a formula to calculate how many times two specific companies, has been working on the same project?
In below example the results should be:
A+B = 2 (in project 10+11)
A+D = 1 (in project 11)
<tbody>
</tbody>
/Skovgaard
Sorry if there is another thread about this, but I can't find any, or I don't know the right search criteria
Please see below table.
Do you know a formula to calculate how many times two specific companies, has been working on the same project?
In below example the results should be:
A+B = 2 (in project 10+11)
A+D = 1 (in project 11)
Project: | Company: |
10 | A |
10 | B |
10 | C |
11 | A |
11 | B |
11 | D |
12 | A |
12 | C |
<tbody>
</tbody>
/Skovgaard