Need to Identify which Companies are unique to a Reseller!!!

This is a variation of a previous question I had last week which sought to count how many unique companies a reseller had: Previous QUestion

Now I need to know which Companies are actually unique to each Reseller.  If possible, I would also like to leave the non-unique ones on the list.  Please see sample attached.

Thanks for any quick help I can get from this!!!
Reseller-and-Company-sample.xlsx
glabossiAsked:
Who is Participating?
 
barry houdiniCommented:
I think you can use this formula in C2 to identify Companies which are only associated with one Reseller

=IF(COUNTIFS(A:A,"<>"&A2,B:B,B2),"","Unique")

Then you can filter that column by "Unique" if you wish

see attached

regards, barry
26896330.xlsx
0
 
TracyVBA DeveloperCommented:
They're all unique.

I concatenated the Reseller and the Company into column C.  Then I used this formula to list out the first unique value of each:

=IF(COUNTIF(C$2:C2,C2)=1,C2,"")

None are blank, so they are all unique.

Reseller-and-Company-sample.xlsx
0
 
glabossiAuthor Commented:
Thanks to both of you for your help but Barry's was exactly what I needed.

G
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.