Associate
- Joined
- 22 Sep 2010
- Posts
- 353
Hello i need to find a function that allows me to display the top 5 value wise of a range of data.
Any help will be welcomed
Any help will be welcomed
Excel Help
- Thread starter Nelson Santos
- Start date
- Joined
- 22 Sep 2010
- Posts
- 353
Total cost is what i need to sort, e.g. So that it displays the top 5 values in a range. Is there a forumla that does this?
Should i just the sort and filter tab and sort by the smallest to largest? And use data from top 5?
The reason i need to do this is to creat a pie chart of the top 5 greatest values, to be inclued in my pie chart.
Sorry if this isnt helpfull
Should i just the sort and filter tab and sort by the smallest to largest? And use data from top 5?
The reason i need to do this is to creat a pie chart of the top 5 greatest values, to be inclued in my pie chart.
Sorry if this isnt helpfull
- Joined
- 22 Sep 2010
- Posts
- 353
Thank you soo much helped loads