We’d like to remind Forumites to please avoid political debate on the Forum.
This is to keep it a safe and useful space for MoneySaving discussions. Threads that are – or become – political in nature may be removed in line with the Forum’s rules. Thank you for your understanding.
📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!
Excel Query
Cotta
Posts: 3,667 Forumite
in Techie Stuff
Morning All,
I have a Pivot tabe with company names in the rows column and their net worth in the values section, is it possible to just list the top 100 companies in terms of their value and if so how?
Thanks
I have a Pivot tabe with company names in the rows column and their net worth in the values section, is it possible to just list the top 100 companies in terms of their value and if so how?
Thanks
0
Comments
-
On 2011 you can select "Top 10" but in reality when you select the option it asks you how many you actually want etc.
On the Row/ Column label you have the drop down to select which values to show/ how to sort etc and the "Top 10" is in the Values Filter sub menu
0 -
Fantastic - worked a treat.0
This discussion has been closed.
Confirm your email address to Create Threads and Reply
Categories
- All Categories
- 352K Banking & Borrowing
- 253.5K Reduce Debt & Boost Income
- 454.2K Spending & Discounts
- 245K Work, Benefits & Business
- 600.6K Mortgages, Homes & Bills
- 177.4K Life & Family
- 258.8K Travel & Transport
- 1.5M Hobbies & Leisure
- 16.2K Discuss & Feedback
- 37.6K Read-Only Boards