+ 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
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    62,012

    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" to anyone who has offered you help in your thread. You can reward them by clicking on * Add Reputation below theur user name on the left, if you wish.


    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite 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
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    3,253

    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
    2,963

    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
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    3,253

    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. 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