+ Reply to Thread
Results 1 to 5 of 5

Find Similar suppliers of Different items in pivot table

  1. #1
    Registered User
    Join Date
    03-07-2004
    Location
    Pakistan
    MS-Off Ver
    MS Office Pro Plus 2016
    Posts
    41

    Find Similar suppliers of Different items in pivot table

    I want to create a pivot table with excel data table .
    date table has purchased items details
    Item
    suppliers
    brans
    model
    purchase date
    Now i want to sort it to know that which items are being supplied by more than one supplier,
    also rate and purchase date with the supplier name.
    best regards.
    Attached Files Attached Files
    I love to learn

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,910

    Re: Find Similar suppliers of Different items in pivot table

    Is this what you want?
    Attached Files Attached Files
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

  3. #3
    Registered User
    Join Date
    03-07-2004
    Location
    Pakistan
    MS-Off Ver
    MS Office Pro Plus 2016
    Posts
    41

    Re: Find Similar suppliers of Different items in pivot table

    Quote Originally Posted by dflak View Post
    Is this what you want?
    Yes, but I want to sort out the list to know which "Items" are supplied by more than one "supplier",
    And Also want to see it as the largest number of supplier for one item on top of the list.
    best regards.

  4. #4
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,910

    Re: Find Similar suppliers of Different items in pivot table

    How about this? If it's what you want, I'll explain how I got it.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    03-07-2004
    Location
    Pakistan
    MS-Off Ver
    MS Office Pro Plus 2016
    Posts
    41

    Re: Find Similar suppliers of Different items in pivot table

    Quote Originally Posted by dflak View Post
    How about this? If it's what you want, I'll explain how I got it.
    All right , that is ok.
    Now please help me to learn this process,
    give a detailed description or any link from where I can learn how to do this.
    I am using Excel 2010
    Best Regards
    Last edited by ndmalam; 12-09-2020 at 12:37 PM.

+ 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. Replies: 11
    Last Post: 01-16-2018, 04:01 PM
  2. Create a table/pivot table using different items items from a column
    By stevetton in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 09-28-2016, 10:30 PM
  3. How to progressively count similar items in a table?
    By TroyMcClure in forum Excel General
    Replies: 1
    Last Post: 05-12-2016, 11:25 AM
  4. Do not group similar items together - PIVOT TABLE
    By sourabhg98 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 02-10-2016, 10:55 AM
  5. Pivot table to find number of items moved given in an amount of time
    By dsoeder in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 02-20-2013, 01:16 AM
  6. Replies: 1
    Last Post: 09-03-2012, 10:03 PM
  7. Grouping similar but not exact items in Pivot Table
    By RobLaw in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-19-2011, 05:20 PM

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