Remove Duplicates in Excel

Posted on June 5, 2013 by Audun Danielsen

How can you remove duplicates from a list in Excel?

Easy! Excel has a built-in feature for this. Just select one of the cells in the list and click on Remove Duplicates on the Data ribbon.

Voilà, the duplicates are gone:

For more advanced ways to handle duplicates (and triplicates, quadruplicates etc.), take a look at this article: How to Find Duplicates and Triplicates in Excel

More Easy Tricks:

Are you using a non-English version of Excel? Click here for translations of the 100 most common functions.

Use Excel to Count Words

Posted on June 4, 2013 by Audun Danielsen

In Word you can easily count the words simply by clicking “Word Count” from the Review ribbon. But what if you have your text in Excel? There is no built-in word count function in Excel, so we have to find another way.

In a previous post I showed how to count characters in a text string using the LEN function. We will use the same function, with a twist, to do a word count.

How to protect cells in Excel

Posted on May 25, 2013 by Audun Danielsen

Why it’s important to protect cells in Excel

If you create an Excel report for someone, it is important that you somehow visualise which cells they are allowed to change, and which cells they should not touch. The common way to do this is to use a blue font for the assumptions, i.e. the values that can be changed.

Unfortunately, this is not always enough. Inevitably, someone will try to enter values into the calculation cells as well, and when they do, the whole report might be useless. We need to protect the cells from being tampered with, and the good news is that it takes less than a minute!

Excel Line Charts: Why the line drops to zero and how to avoid it

Posted on May 13, 2013 by Audun Danielsen

Have you ever seen a line chart in Excel that’s suddenly dropping to zero? Here’s why it happens and what to do about it:

Let’s say you have a table where you enter new sales figures every day, and a line chart connected to it. The sales figures for the last few days in the table have not yet been filled out, so the last values for the y-axis are zero. This is what the line chart could look like:

How to Create an HTML Table with Excel

Posted on May 6, 2013 by Audun Danielsen

If you write something for a webpage, chances are that you write the text in HTML code. If you’re used to it, it often turns out to be easier than writing the text in a What-you-see-is-what-you-get-editor (WYSIWYG). In my experience, the WYSIWYG-editors never really work the way you want, so the HTML editor turns out to be better after all.

But what if you want to use a table that you have created in Excel? How can you transform an Excel table into a piece of HTML code that looks like this?

How to use Excel to Count Characters in a Text String

Posted on May 3, 2013 by Audun Danielsen

We often need to measure the length of a text, for example if we write a text that will appear on a website. Typically, in a web shop the product introduction text has to be of a certain length in order to fit within the frames.

Of course, the easiest way to do this is in Excel. This is extremely easy – it only takes a few seconds:

Easy-Excel.com

Find Easy Solutions to Your Excel Problems!

Category Archives: Easy Tricks