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 ddalgleish@contextures.com

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:

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.

Spring Blossoms

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.


Contextures Products

Save time with our "Done For You" Excel products.

Note: I am an affiliate for some of the products mentioned in this newsletter, and earn a commission on the sales.




Privacy Policy


Contextures Inc., Copyright 2019
All rights reserved.