+ Reply to Thread
Results 1 to 2 of 2

Conditional sum and sorting out top sums

  1. #1
    Registered User
    Join Date
    10-25-2008
    Location
    Norway
    Posts
    3

    Conditional sum and sorting out top sums

    Hi

    I am analysing a large amount of data related to monthly product sales and would like to extract the top selling products within various categories in an automatic manner. I know this can be done manually by using the filter and twisting things around, but I need it to be as automatic as possible - and since this is monthly data the top products might change depending on the period.

    I am currently using the conditional sum to get the sums of all the products sold within the various categories, but need to find a formula that at the same time sorts the data so I only get the top products. Any tips?

    Would very much appreciate your help!

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Conditional sum and sorting out top sums

    Perhaps use a Pivot Table ?
    (you can group dates by month and you can filter based on Top n results etc...)

    (the PT can itself be sourced from a Dynamic Named Range such that it resizes based on latest data)

    Post a sample if you want more specific assistance and update your profile to include your XL version)

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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