Search Contextures Sites
Excel Weekly News from Contextures Dec 03, 2013
Remove duplicates from a list + more Excel tips
In this week's Excel news, you'll see how to remove duplicates from a list, and other tips. Thank you for reading the Excel news!
- Debra email@example.com
Excel Timetable for Your Holiday Dinner
If you’re responsible for getting the family meal during the holiday season, you can use my Excel Holiday Dinner Planner. Enter all the dinner items, then go to the top of the worksheet, and select the time that you want to serve dinner. Automatically, the Excel dinner planner calculates the preparation start time for each item
Click here to see the details, and download the sample file: Excel Timetable for Your Holiday Dinner
Count Unique Items in Pivot Table With Excel 2013 PowerPivot
A normal pivot table in Excel can't create a unique count (distinct count) for a field. However, if you have the PowerPivot add-in installed, in Excel 2010 or 2013, you can use its DISTINCTCOUNT function.
In this tutorial, you'll see how to connect to an Excel file that contains the data, build a pivot table, and show a distinct count.
Click here to see the details, and watch the video: Count Unique Items in Pivot Table With Excel 2013 PowerPivot
Remove Duplicates in Excel List
With the Remove Duplicates feature in Excel (2007 and later), you can quickly remove all the duplicated items in a single or multi-column list on a worksheet. In this example, we can keep just a list of unique products, or a list that show each product, and all its prices changes.
Click here to see the details, and watch the video: Remove Duplicates in Excel 2013 List
More Excel Tips
Here are a few more Excel articles that I read this week, that you might find useful:
- It's too late for Thanksgiving, but you could use this next year. Stephen shows how to cook a turkey with Excel, by calculating the time to thaw and cook the bird. You’ll have to use an oven though – you can’t actually cook the turkey with Excel.
- This could cause problems -- Cameron Lackpour shows how multiple workbooks with links to the same source automatically update each other.
- If you haven’t used Microsoft’s Power Query add-in yet, Arshad Ali shows how to get started
- 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: Count Duplicates With a Simple Pivot Table
In one of this week's tips, you saw how to remove duplicates from a list. If you want to count the duplicates, instead of removing them, you can create a pivot table to count the list items.
First, add a heading to the list, if there isn't one already. Then, create a pivot table from the list, with the same field in the Row Labels area and the Values area. Watch this video to see the steps.
Winter Has Arrived
I guess it was inevitable -- winter has finally arrived, dusting our city with a light coating of snow. It looks pretty on the trees, like this spruce in our front yard. It's not so nice on the street though, and I'm glad to have the snow tires on my car!
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 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 ©2014
All rights reserved.