Microsoft Excel: How to find top 10 figures based on a condition like country wise

15 pts.
Tags:
Microsoft Excel
I do have sales figures country wide and i would like to make a separate table for each country and populate top 10 sales figures in XLS. Thanks in advance.


Software/Hardware used:
MS Excel
0

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • Subhendu Sen
    What version of excel are you using now. For this purpose, you can take help from pivot table of MS office utility.
    140,740 pointsBadges:
    report
  • TheRealRaven
    That seems like a pretty basic problem for someone working with multi-national sales.

    How many total sales data points do you have? How many countries are represented?
    36,035 pointsBadges:
    report
  • rangagom

    i am using xls 2007. I used large function but i am not getting desired output.

    D             E                     F 

    12344    Netherlands      1

    12234   London               2

    10000   Netherlands        3

    20000   Americas            4

    i used =large(if(E:E="Americas",D:D,""),F1) formula

    15 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: