Count Unique Text of a column based on Duplicates in another column

[learningstatistics]

Hello,

I am trying to count unique text in a column based on duplicates in another column. For example, I have this
[TABLE="width: 500"]
<tbody>[TR]
[TD]A[/TD]
[TD]person x[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]person y[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]person x[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]person x[/TD]
[TD]1[/TD]
[/TR]
</tbody>[/TABLE]

So in the above table column one shows the duplicates . I am counting the Unique texts in column 2.
So, for the duplicate A, I have two unique people (person X and person Y). But for the duplicate B, I only have one person.

How can I do this in the most efficient way?

Thank you!!!

 

[James006]

Hello,

The most efficient way ... is to Insert a Pivot Table ...

In less than five seconds ... it will produce your result ...

Hope this will help