All articles with 'remove duplicates' Tag

CP043: My favorite time saving features of Excel, Revealed.

Published on Aug 27, 2015 in Chandoo.org Podcast Sessions
CP043: My favorite time saving features of Excel, Revealed.

In the 43rd session of Chandoo.org podcast, let’s talk about top time saving features of Excel.

What is in this session?

In this podcast,

  • Quick announcement about Awesome August
  • My 9 favorite time saving features of Excel
  • Remove Duplicates
  • Tables
  • Pivot Tables
  • Auto fill
  • Format Painter
  • Find & Replace
  • VBA / Macro Recorder
  • Auto save
  • Auto complete / Intellisence
  • Recap & Conclusions
Continue »

Remove duplicate combinations in your data [quick tip]

Published on Aug 7, 2015 in Excel Howtos
Remove duplicate combinations in your data [quick tip]

By now, we know how to remove duplicates from data. You can use the Remove Duplicates button to do that.

But do you know that we can use remove duplicates button to get rid off duplicate combinations too?

Remove duplicate combinations – Tutorial

To remove duplicate combinations in your data, just follow below 4 steps:

  1. Select your data
  2. Click on Data > Remove Duplicates button
  3. Make sure all columns are checked
  4. Click ok and done!

See this demo:

Continue »

CP021: How to quickly compare 2 lists in Excel

Published on Oct 2, 2014 in Chandoo.org Podcast Sessions, Excel Howtos
CP021: How to quickly compare 2 lists in Excel

In the 21st session of Chandoo.org podcast, lets compare lists. Quickly

What is in this session?

Comparing things is a favorite pastime for analysts all over the world. Sadly, it is also an area where we waste hours. So in this episode, I share my top secret comparison techniques to save you time.

Note: This is a short format podcast. That means you spend less time listening to it, while becoming more awesome.

In this podcast, you will learn,

  • Why I sound like I am on a secret mission at a mafia hideout.
  • 5 ways to compare 2 lists
    • Manual method
    • Conditional Formatting
    • Row Differences
    • LOOKUP formulas
    • COUNTIF formulas
  • Bonus tip: Removing duplicates
  • Conclusions
Continue »

Excel Links – Next Dashboard Contest Edition

Published on Dec 13, 2010 in excel links
Excel Links – Next Dashboard Contest Edition

Almost an year ago, we had a memorable dashboard contest on Sales Dashboards. We got 32 beautiful, outstanding, well crafted entries and it was a lot of fun learning new tricks & meeting new members of our community. I am planning to have one more dashboard contest and I need your help.

I need you to suggest a topic for the contest (optional: and give some sample data)

Just drop a comment with your suggestions (and point to source data if any). We will have a dashboard contest on one of those topics.

Read the rest of this post to get some useful Excel related links.

Continue »

Remove duplicates & sort a list using Pivot Tables

Published on Sep 27, 2010 in Analytics, Learn Excel, Pivot Tables & Charts
Remove duplicates & sort a list using Pivot Tables

Removing duplicate data is like morning coffee for us, data analysts. Our day must start with it. It is no wonder that I have written extensively about it (here: 1, 2, 3, 4, 5, 6, 7, 8). But today I want to show you a technique I have been using to dynamically extract and sort […]

Continue »

Data Validation using an Unsorted column with Duplicate Entries as a Source List

Published on Feb 2, 2010 in Learn Excel
Data Validation using an Unsorted column with Duplicate Entries as a Source List

Here is a typical scenario: We want to allow only one of the pre-defined customer names in our spreadsheet. We have listed down all the customers in column B and want excel to check against this list and validate the data. But there are 3 problems. (1) Our list is not sorted alphabetically (2) It contains duplicates and (3) The list comes from external source, so we can not remove duplicates and sort the list every time.

Now how can we set up a simple data validation list that would not repeat customer names and shows them in sorted order like this.

Read the rest of this guest post by Hui to learn how to use data validation in creative new ways.

Continue »

Count the number of unique values in a range [Quick Tip]

Published on Aug 6, 2009 in Excel Howtos, Learn Excel
Count the number of unique values in a range [Quick Tip]

Here is an excel formula quick tip that can come handy when you need to count the number of unique values in a range of cells. Assuming we have a list of values in the range:B5:B15 and we want to know how many unique values are there,
you can use the almighty SUMPRODUCT formula like this: SUMPRODUCT(1/COUNTIF(B5:B15,B5:B15)).

Read the rest of this post to understand how the formula works. You can also find resources to work with duplicate values in excel.

Continue »

Remove Duplicates [Quick Video Tip]

Published on Jun 22, 2009 in Excel Howtos

It is very surprising that so many of us are still not aware of this extremely powerful tool in Excel 2007. Just with a click of the button, you can remove all the duplicate values from a list / table. To remove duplicates, (1) Just select the list of values from which you want to remove duplicates (2) Go to Data ribbon (3) Hit the Remove Duplicates button (4) Bingo…

Continue »