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!!!
Who is Participating?
barry houdiniConnect With a Mentor Commented:
I think you can use this formula in C2 to identify Companies which are only associated with one Reseller


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

see attached

regards, barry
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:


None are blank, so they are all unique.

glabossiAuthor Commented:
Thanks to both of you for your help but Barry's was exactly what I needed.

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.