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).
<tbody>
</tbody>
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!
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).
File ID | Operator Name |
123ABC | John |
123ABD | Adam |
123ABB | Alex |
123ABC | John |
123ABC | John |
123ABB | John |
123ABD | John |
123ABD | Adam |
<tbody>
</tbody>
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!