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

  1. 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.
  2. This could cause problems -- Cameron Lackpour shows how multiple workbooks with links to the same source automatically update each other.
  3. If you haven't used Microsoft's Power Query add-in yet, Arshad Ali shows how to get started
  4. 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!


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.