How to get a record in column A with unique value in column B ?

Hello all,

I am looking for a help with the problem and I would appreciate your suggestions.

I have a data with two important columns.

column A Column B
customer 1 partner ABC
customer 1 special partner Germany
customer 2 special partner UK
customer 3 special partner UK
customer 3 special partner Spain
customer 4 partner XYZ
customer 4 partner QWE
customer 4 special partner UK


And I need the list of all customers having only special partner (the county doesn't matter)
So the correct ones are customer 2 and customer 3.

I have almost 300 000 records so it's hard to filter it in pivot table for me.

Any idea how to get the list of customer with special partner ?

I appreciate any help with this problem.
Thanks,

Logic is missing why not "customer 1 special partner Germany" and "customer 4 special partner UK"?

Regret for the delay in reply since I was not in online. Now I can able to understand the logic.

I believe that your first row will have column headers and your data starts from 2nd Row.

In C2 cell

Formula:

Please Login or Register  to view this content.

Drag it down.

Adapt the last row 40000 to your Last Row of your data.

Refer the attached file for details.