Excel Weekly News from Contextures May 27, 2014
New SHEET functions + more Excel tips
In this week's Excel news, you'll see how to troubleshoot with SHEET functions, and other tips. Thank you for reading the Excel news!
- Debra firstname.lastname@example.org
There isn't a built-in function that shows a unique count in a pivot table. You can see the sum of sales, or the count of orders, but not the number of unique (distinct) stores where those orders were sold. Roger Govier shares two techniques that let you create a unique count -- one method for Excel 2010 and later, and one method for earlier versions.
Click here to see the details, and download the sample file: Unique Count in Pivot Table
When you show totals by date in a pivot table, you can list each date, or group the dates. In this example, we'll group the dates into 4-week periods, to match the periods in the company's sales calendar. Then, set a starting date for the grouping, so that the periods start on your preferred day of the week
Click here to read the details, and watch the video: Group By Weeks in Excel Pivot Table
There are new functions in Excel 2013 that let you calculate the sheet number or the number of sheets in a workbook. You can use these functions to help with troubleshooting, and to discover if any sheets are hidden.
Click here to see the details, and watch the video: SHEET and SHEETS Functions in Excel 2013
Here are a few of the Excel articles that I read last week, that you might find useful:
Excel's MATCH function finds items in a list, and returns the postion number. You can combine MATCH with VLOOKUP, to create flexible lookup formulas.
Spring is in full force, here in Canada, and the combination of rain and warmer weather is making everything grow rapidly. Unfortunately, that means the weeds are growing too! These little forget-me-not flowers are pretty, but they are taking over the lawn, so they'll have to be treated like weeds, and pulled out.
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.