+ Reply to Thread
Results 1 to 4 of 4

Need to Find Items Most Frequently Purchased Together

  1. #1
    Registered User
    Join Date
    07-27-2019
    Location
    San Francisco
    MS-Off Ver
    Mac 16.24
    Posts
    3

    Need to Find Items Most Frequently Purchased Together

    I have a list of purchase ids and a list of product ids and I would like to see what products are most commonly purchased in pairs. Is there an easy way to do this? I tried using a SUMPRODUCT function but I most have done something wrong because the numbers are not making sense. If anyone has recommendations on how to do this (with or without the SUMPRODUCT function), I would greatly appreciate it.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365
    Posts
    20,228

    Re: Need to Find Items Most Frequently Purchased Together

    Welcome to the forum

    Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

  3. #3
    Registered User
    Join Date
    07-27-2019
    Location
    San Francisco
    MS-Off Ver
    Mac 16.24
    Posts
    3

    Re: Need to Find Items Most Frequently Purchased Together

    Here is an example of the type of data I would be working with and the example output I am looking for.

    Please let me know if you need any further info. Thank you so much for your help!
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    07-27-2019
    Location
    San Francisco
    MS-Off Ver
    Mac 16.24
    Posts
    3

    Re: Need to Find Items Most Frequently Purchased Together

    Does anyone have any tips or suggestions? Thanks.

+ 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. how to find most To most frequently occurring numbers in a column
    By eddie01001 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-10-2019, 07:32 PM
  2. Replies: 4
    Last Post: 02-06-2019, 08:11 AM
  3. [SOLVED] How to find last purchased price of an item?
    By sochenda in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-20-2018, 10:53 AM
  4. [SOLVED] Total items purchased within fiscal year using a dropdown.
    By helmerr in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-19-2017, 03:28 PM
  5. items most frequently picked together
    By xxsinghxx in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-31-2016, 03:55 PM
  6. Populating Vouchers With Purchased Items For Auction
    By ElectroPulse in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 10-27-2015, 11:55 PM
  7. how to make a chart for frequently used items
    By teetrinity in forum Excel General
    Replies: 0
    Last Post: 02-17-2006, 07:25 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