• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Extract Top 20 Values from a list based on criteria

M

Muthukumar Rajaram

New Member
Hello all,

This is my first question in this forum.

I have a pivot table which is a list customers (Column B in the attachment) who have a set budget (locked number - Column C) and also sales forecast (Column D - which can be adjusted on a monthly basis). The customers are categorized by Industry groups (for example - Dry Goods, Fruit & Produce, etc).

What i want to do is to have a "Summary" tab which will have a drop down cell to select the Industry Group) and a table to display the top 30 customers based on their budget numbers.

I have tried using an array formula and it doesn't seem to be working.
Can someone please help?

Thanks very much.
Muthu
 

Attachments

  • Top 30 Customers - Sample File.xlsx
    62.6 KB · Views: 4
rahulshewale1 said:
hiii,

Please find the attached formula base solution

Thanks
Rahul shewale
Click to expand...
Rahul, Thanks again.

Now, what if i want to add another Criteria of State - as in Top 20 in the selected state for the selected industry group?

Thanks,
Muthu
 

Attachments

  • Top 30 Customers - Sample File.xlsx
    70.2 KB · Views: 3
Thanks very much Rahul.
Apologies for the late reply.

I have another question. Attached is the sample file. I have a variance between Budget and Forecast in the sample pivot tab.

And in the Summary tab, i would like to see Top 5 Customers who are tracking above budget and Top 5 Customers who are tracking below budget based on the State selected in cell B2.

Thanks in advance for your help.
 

Attachments

  • Top 5 Above and Below Customers.xlsx
    79.4 KB · Views: 7
You must log in or register to reply here.
Back
Top