Solved

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

Posted on 2011-03-18
3
264 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

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

Suggested Solutions

Drop Down List with Unique/Distinct Values (enhancing the Combo-Box with a few steps and a little code) David miller (dlmille) Intro Have you ever created a data validation list from a database field or spreadsheet column (e.g., Zip Codes or Co…
Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

708 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now