Hey everyone
I hope someone can help me with the following.
I have a sheet with companies (Column A) and their subsidiaries(Column B) and the country where those sub sidiariesoperate (Column C). It looks something like this:
<tbody>
</tbody>
I use the COUNTIF function to determine the number of subsidaries per company withiin a given country. I do this by manually adjusting the range within the COUNTIF function. Is there a more easy way do this, by automatically determining the range per company. So as in the example, in the case of company 1 range A2:A4, company 2 A5, company 3 A6:A7, and so on.
Thanks in advance!
I hope someone can help me with the following.
I have a sheet with companies (Column A) and their subsidiaries(Column B) and the country where those sub sidiariesoperate (Column C). It looks something like this:
| Company | Subsidiary | Location |
| Company 1 | A | US |
| Company 1 | B | JP |
| Company 1 | C | CH |
| Company 2 | D | FR |
| Company 3 | E | JP |
| Company 3 | F | JP |
| Company 4 | G | FR |
| Company 4 | H | US |
| Company 4 | I | UK |
| Company 4 | J | UK |
| Company 4 | K | UK |
| Company 5 | L | UK |
| Company 5 | M | US |
| Company 5 | N | US |
| Company 5 | O | US |
<tbody>
</tbody>
I use the COUNTIF function to determine the number of subsidaries per company withiin a given country. I do this by manually adjusting the range within the COUNTIF function. Is there a more easy way do this, by automatically determining the range per company. So as in the example, in the case of company 1 range A2:A4, company 2 A5, company 3 A6:A7, and so on.
Thanks in advance!
