+ Reply to Thread
Results 1 to 7 of 7

Inventory, Products, Commonly picked together products

  1. #1
    Registered User
    Join Date
    05-29-2021
    Location
    London, England
    MS-Off Ver
    MS365
    Posts
    3

    Inventory, Products, Commonly picked together products

    Hey,
    I have a warehouse of 7000 different products. Each with a unique 8 digit number.
    I have thousands of orders each day each with a unique order number for each order.
    I am attempting to find out which products are most commonly picked together so that I can physically put them closer together.
    Because at the moment the products just go all over the place.
    I have tried using pivot tables but for the sheer amount of data I have this is just not usable.
    Can anyone help?

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,348

    Re: Inventory, Products, Commonly picked together products

    Welcome to the forum.

    There are instructions at the top of the page explaining how to attach your sample workbook.

    Your version of Office is MS365, judging by the information you've given - please update your profile accordingly. Thanks.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Registered User
    Join Date
    05-29-2021
    Location
    London, England
    MS-Off Ver
    MS365
    Posts
    3

    Re: Inventory, Products, Commonly picked together products

    thank you! updated my profile to show MS365, can't upload a sample workbook unfortunately

  4. #4
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,295

    Re: Inventory, Products, Commonly picked together products

    How do you expect us to help you if you are unable/unwilling to upload a sample workbook.
    We do not want all your 7000 items, just a 10/20 rows of typical layout/data - de-sensitised.
    Otherwise unfortunately I fear it will be a long wait, as serviceable crystal balls are in short supply.
    torachan.

  5. #5
    Registered User
    Join Date
    05-29-2021
    Location
    London, England
    MS-Off Ver
    MS365
    Posts
    3
    A crystal ball isn't needed...
    Just some manners and some Excel knowledge...

  6. #6
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    3,255

    Re: Inventory, Products, Commonly picked together products

    A ball is not needed but an excelfile is highly recommended
    Willem
    English is not my native language sorry for errors
    Please correct me if I'm completely wrong

  7. #7
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,295

    Re: Inventory, Products, Commonly picked together products

    @swanagemusic, as my friends will vouch, my manners are impeccable, alas my manner is direct.
    You are starring daily at your unsolved problem, all we need is a momentary glimpse to relieve you of your angst.
    torachan.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Separation of unsold products from all duplicate products
    By Yaghoub61 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-05-2021, 01:54 AM
  2. Replies: 8
    Last Post: 07-01-2016, 02:07 AM
  3. Replies: 6
    Last Post: 03-05-2016, 02:42 PM
  4. Formula to work out how many products among various products!
    By MissConfussed in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 05-02-2013, 02:24 PM
  5. Replies: 6
    Last Post: 02-21-2013, 10:17 PM
  6. Best Method for Child Products - Inventory
    By stitchez in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-29-2012, 06:16 AM
  7. [SOLVED] Products
    By Gene in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-20-2005, 08:07 PM

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