Hi all
The table I'm working with is for finding companies that make specfic products. You put the product code in cells c3:g3, and the file displays whether or not the carry the product, and how many we have purchased in the last 3 months (ex. Yes - 3). Column I = number of the specified products the company sells, Column J is the number of the specfic products we've purchased from the company in the last 3 months, and Column K is the total number of products we've purchased from the company in the last 3 months.
I've attached a sample of the file I'm working with. The first table is how I am able to sort the data. The second table is how I want to sort it. I want the companies that offer the same group of products to be grouped together.
For example, I want company 45 to be grouped with company 42 and 43 because they all offer Products 1, 2, 3, & 5.
Any ideas how to do this?
Thanks in advance!
Bookmarks