Solved

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

Posted on 2011-03-18
3
268 Views
Last Modified: 2012-05-11
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
0
Comment
Question by:glabossi
3 Comments
 
LVL 24

Expert Comment

by:broomee9
ID: 35166100
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
 
LVL 50

Accepted Solution

by:
barry houdini earned 500 total points
ID: 35166192
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
 

Author Closing Comment

by:glabossi
ID: 35167604
Thanks to both of you for your help but Barry's was exactly what I needed.

G
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

740 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question