+ Reply to Thread
Results 1 to 4 of 4

Top 3 products based on multiple criteria (Name and Amount)

  1. #1
    Registered User
    Join Date
    08-19-2015
    Location
    London, England
    MS-Off Ver
    2013
    Posts
    55

    Top 3 products based on multiple criteria (Name and Amount)

    Hi,

    I'm trying to get a Top 3 from a list of Products, based on multiple criteria.

    If possible, I'd like the results from Top 1 to 3 in one cell, with the amount of occurrences next to it.
    Any help would be appreciated...

    ExampleNew.png

    Many thanks in advance...
    Attached Files Attached Files

  2. #2
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Top 3 products based on multiple criteria (Name and Amount)

    A Pivot Table would seem the most efficient way. However I don't understand how you arrive at some of your numbers.

    Why for instance in week 50, No discount, Butter do you have a count of 11 when there are only 8?

    See attached
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    08-19-2015
    Location
    London, England
    MS-Off Ver
    2013
    Posts
    55

    Re: Top 3 products based on multiple criteria (Name and Amount)

    Hi Richard,

    Thanks for your help. I must be getting old, if my calculations are off ;-) My bad..!

  4. #4
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Top 3 products based on multiple criteria (Name and Amount)

    That's the beauty of a Pivot Table. It requires no calculations whasover.

+ 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. Multiple products selection with automatic price based on quantity/volume
    By murilo.costa in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-30-2018, 08:39 AM
  2. [SOLVED] Calculate Cost of Products Based On Multiple Criteria
    By DomLeRoy in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 11-09-2017, 05:26 AM
  3. [SOLVED] Return total amount values based on multiple criteria
    By MyStix01 in forum Excel General
    Replies: 3
    Last Post: 10-12-2017, 09:05 AM
  4. Replies: 8
    Last Post: 07-01-2016, 02:07 AM
  5. [SOLVED] Different discount for different products amount
    By AugustsD in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 03-30-2015, 07:28 AM
  6. sum and frequency of data & sum of amount based on criteria
    By joeldlow in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-09-2014, 02:28 AM
  7. sumif-add amount to another cell based on two criteria
    By gabrielinlompoc in forum Excel General
    Replies: 0
    Last Post: 02-09-2006, 08: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