mmj1
asked on
Excel 2013 - help with sorting/extracting data
I have an Excel 2013 spreadsheet with over 3,000 entries. The spreadsheet has customer numbers and Company Names (see attached sample) - my original spreadsheet has many more columns but I tried to simplify for explanation purposes. On the sample I have attached there are five customer numbers (3, 4, 5, 6, 7) and only two company names. I am trying to find a quick way to determine what customer numbers are listed with both companies. So in my example, customer #4, #5 and #7 are the customers that are associated with both companies. That is what I am trying to extract. I don't need to know the customer numbers that are only associated with one company. I need to pull only the customer numbers that are listed for both companies. Any help is appreciated. Thank you.
No attachment :)
ASKER
Sorry!
Sample.xlsx
Sample.xlsx
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Here is a Pivot method as well
mmj1_Sample_v2.xlsx
mmj1_Sample_v2.xlsx
ASKER
Thank you all for your responses. When I use the Pivot Table method that does show me all of the customers whether they have one or two companies listed; however, I am trying to end up with a list of only the customers that have two companies listed and remove the customers that have only one customer listed. Not sure if this is possible. Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Rob, that worked great. Thanks to all for your help!!