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 email@example.com
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
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
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
Here are a few of the Excel articles that I read last week, that you might find useful:
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.
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.
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.