Microsoft Excel is perhaps the most powerful spreadsheet application you can buy. But it also has some simple functions, like finding duplicates in data.

However, Excel's random number functions are volatile, meaning they change constantly. In this article, I'll show you how to generate and fix random numbers and remove duplicates.

How can we find duplicate values across multiple columns? For this task, we’ll use two Excel helper formulas: One to concatenate the columns you’re comparing; a second to count the duplicates.

Microsoft Excel allows you to crunch massive quantities of data easily through the use of functions. Sometimes you need to know the number of actual data points without counting blank cells. As an ...

Learn how to count the number of words in Microsoft Excel. Use this Function to get the word count easily - with or without spaces.

If your spreadsheet has a lot of unwanted duplicate values, you're not stuck with them. You can remove them. We'll show you how to remove duplicates in Excel.