+ Reply to Thread
Results 1 to 5 of 5

Identifying top Vendors who contribute to refunds and Top 70% Items for refunds

  1. #1
    Forum Contributor
    Join Date
    10-18-2016
    Location
    Chicago, USA
    MS-Off Ver
    2010
    Posts
    110

    Red face Identifying top Vendors who contribute to refunds and Top 70% Items for refunds

    Hi All,

    Hope you are doing well!...I am trying to identify a formula to identify the top 5 vendors for the categories Backorder and Pre-sell according to the amounts refunded ...Also I am trying the find the top 70% of the items contribution by Pre-sell and Backorder category..This will list the itemid with the number of times the itemid appears in the list with the refunds sorted in descending order contributing to the top 70% for each individual category Pre-sell and Backorder..

    I have all the input data in the main sheet and the required outputs in the next three tabs...Can you please help me with the formula for the same..

    Thanks,
    Arun
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    11-02-2016
    Location
    NY
    MS-Off Ver
    2010
    Posts
    366

    Re: Identifying top Vendors who contribute to refunds and Top 70% Items for refunds

    I put into Pivot Tables on the 1st tab.
    Attached Files Attached Files

  3. #3
    Forum Expert PaulM100's Avatar
    Join Date
    10-09-2017
    Location
    UK
    MS-Off Ver
    2016
    Posts
    2,024

    Re: Identifying top Vendors who contribute to refunds and Top 70% Items for refunds

    Based on queuesef's pivot tables, you could do a running total % field and find the top 70% as well
    Click the * to say thanks.

  4. #4
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    13,764

    Re: Identifying top Vendors who contribute to refunds and Top 70% Items for refunds

    In the future:

    Please also refer to your question below, which seems similar to the one you post above.

    https://www.excelforum.com/excel-pro...-of-items.html
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  5. #5
    Forum Expert Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    4,234

    Re: Identifying top Vendors who contribute to refunds and Top 70% Items for refunds

    For Top 70%

    A2
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    C2
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    or Power Query

    Please Login or Register  to view this content.
    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)

Similar Threads

  1. Power Query for identifying the top 5 vendors by category and the top 70% of items
    By chandramouliarun in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-15-2020, 12:49 PM
  2. [SOLVED] Grouped items and identifying the group
    By malcmail in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 05-22-2020, 12:21 PM
  3. Excel 2007 combined with Outlook 2007 and dropbox to process refunds
    By marcbarnett in forum Outlook Formatting & Functions
    Replies: 0
    Last Post: 05-14-2014, 04:40 AM
  4. Replies: 6
    Last Post: 11-27-2013, 10:28 PM
  5. Sum of Sales - Refunds in pivot table (both positive values), How to?
    By Kenny_Lundbeck in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-11-2013, 06:26 AM
  6. [SOLVED] How about IRS tax preparation form that helps prepare refunds.
    By Krini27 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 02-16-2005, 12:45 PM
  7. How about IRS tax preparation form that helps prepare refunds.
    By childofGod_333 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 02-16-2005, 12:45 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