Hi!
I have a large dataset consisting of column A and B. In column A there is an ID that represents a voyage. In column B I have names on the persons that were on the different voyages. I want to calculate how many unique persons that were on the different voyages. How do I do that?
Below I have shown a small table to give an idea of how it looks.
<tbody>
</tbody>
Hope someone can help.
Thank you!
I have a large dataset consisting of column A and B. In column A there is an ID that represents a voyage. In column B I have names on the persons that were on the different voyages. I want to calculate how many unique persons that were on the different voyages. How do I do that?
Below I have shown a small table to give an idea of how it looks.
ID | Name |
1 | Peter |
1 | Jacob |
1 | Michael |
1 | Jens |
2 | Jens |
2 | Trevor |
2 | Peter |
3 | Jacob |
3 | Michael |
<tbody>
</tbody>
Hope someone can help.
Thank you!