Results 1 to 5 of 5

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

Threaded View

  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

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