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 firstname.lastname@example.org
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
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
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
Here are a few more Excel articles that I read this week, that you might find useful:
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.
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!
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.