Hi,
I have a table of unique emails with corresponding company and country.
I want to have a column which counts the number of unique countries a company is active in.
Column D is where I want the count to be in. Can someone help me with a formula for this?
<tbody>
</tbody>
I have a table of unique emails with corresponding company and country.
I want to have a column which counts the number of unique countries a company is active in.
Column D is where I want the count to be in. Can someone help me with a formula for this?
Company | Country | #Countries | |
xxx | A | France | 3 |
xxx | A | Germany | 3 |
xxx | A | UK | 3 |
xxx | B | France | 1 |
xxx | B | France | 1 |
xxx | C | Germany | 2 |
xxx | C | UK | 2 |
<tbody>
</tbody>