Excel Weekly News from Contextures Mar 18, 2014
Show Top 10 + more Excel tips
In this week's Excel news, you'll see how to show the Top 10 filtered items, and other tips. Thank you for reading the Excel news!
- Debra firstname.lastname@example.org
- Show Top 10 After Filtering
- Report Filter Items Out of Order
- Dependent Drop Down Lists With Tables
- More Excel Tips
- Video: Vlookup from Different Workbook
- Weekly Photo: Spring Blossoms
- Excel Tools
Show Top 10 After Filtering
Sometimes the Top 10 filter doesn't show the results that you expect. For example, if you filter a list to show only the Sunday sales, then filter for the Top 10 of those sales, only 2 rows are left.
Click here to see why this happens, and how you can get the results that you need: Top Ten Values in Filtered Rows
Report Filter Items Out of Order
If the items in a pivot table Report Filter drop down are out of order, here's how to sort them. This will make it easier to find a date, or other items, in a long list.
Click here to see the details: Sort Items in Excel Pivot Table Report Filter
Dependent Drop Down Lists With Tables
You can create drop down lists on a worksheet, with data validation. Roger Govier shares his technique for building dependent drop down lists -- select a region, then a country, an area, and then a city.
Click here to see the details: Dependent Drop Down Lists With Tables
More Excel Tips
Here are a few of the Excel articles that I read last week, that you might find useful:
- Jon Acampora recommends the best keyboards if you like to use Excel's keyboard shortcuts. My laptop keys looks like most of the "bad" pictures in the article.
- The FrankensTeam did a guest post on Jon Peltier's blog, showing their approach to plotting gaps in Excel charts.
- Chandoo shows us the 6 best charts to use, when you want to show your progress against a goal. There's a sample file to download, so you can experiment on your own.
- Ross Hall explains what you should do if you inherit a spreadsheet that nobody really understands.
- Finally, for a humorous peek at what other people are saying about Excel, read this week's collection of Excel tweets, on my Excel Theatre blog.
Video: VLOOKUP From Different Workbook
In a VLOOKUP formula, you can refer to a lookup table that is in a different Excel workbook. It is easier to create the reference if both Excel workbooks are open when you create the formula. After you create the formula, the price list workbook can be open or closed, and the formula will continue to work correctly. This short video shows the steps for setting up the formula.
Maybe spring will arrive after all, despite the harsh winter we've had across most of North America. These pretty pink blossoms, that I saw last week, give me hope that warmer weather is just around the corner.
Recommended Excel Tools
In addition to all the free Excel tips and tutorials, there are other Excel tools that you can invest in. To learn more about the products listed below, click on the links to take a look at their features, and decide if they're right for you.
- Contextures Excel Tools Add-in
- Contextures PivotPower Premium Add-in
- Contextures 30 Excel Functions in 30 Days
- Excel Online Course
- Excel Charting Tools
- Excel Dashboard Kits
- Excel Project Management Templates
- Excel VBA School
Note: I am an affiliate for some of the products mentioned in this newsletter, and earn a commission on the sales.
Contextures Inc., Copyright ©2017
All rights reserved.