+ Reply to Thread
Results 1 to 1 of 1

Sorting data by grouped results

  1. #1
    Valued Forum Contributor Melvinrobb's Avatar
    Join Date
    06-19-2012
    Location
    Manitoba, Canada
    MS-Off Ver
    Excel 2013
    Posts
    1,128

    Sorting data by grouped results

    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!
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1