Counting multiple occurrences of a number

[rac241985]

Hello Everyone,

Column A contains multiple file ID numbers which can be repeated .

Column B contains the operator name who will work on the these file numbers.

I want to count the total number of unique file ID numbers which an operator will work on (i.e. not counting the repeated file ID numbers again).

[TABLE="width: 500"]
<tbody>[TR]
[TD]File ID[/TD]
[TD]Operator Name[/TD]
[/TR]
[TR]
[TD]123ABC
[/TD]
[TD]John [/TD]
[/TR]
[TR]
[TD]123ABD[/TD]
[TD]Adam[/TD]
[/TR]
[TR]
[TD]123ABB[/TD]
[TD]Alex[/TD]
[/TR]
[TR]
[TD]123ABC[/TD]
[TD]John[/TD]
[/TR]
[TR]
[TD]123ABC[/TD]
[TD]John[/TD]
[/TR]
[TR]
[TD]123ABB[/TD]
[TD]John[/TD]
[/TR]
[TR]
[TD]123ABD[/TD]
[TD]John[/TD]
[/TR]
[TR]
[TD]123ABD[/TD]
[TD]Adam[/TD]
[/TR]
</tbody>[/TABLE]

As you can see in this example there are 3 different File IDs and three different operators. John has worked on all three of them multiple times. However, I want the output for total number of unique files John has worked on to be 3.

Can someone please help me with the formula?

Thank you!

 

[RedBeard]

This might be of help: https://support.office.com/en-us/ar...e-occurs-aa1f3067-05c9-44e4-b141-f75bb9bb89bd