glabossi
asked on
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks to both of you for your help but Barry's was exactly what I needed.
G
G
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,C
None are blank, so they are all unique.
Reseller-and-Company-sample.xlsx