Recent Articles

Red markup boxes showing the file patch for opening duplicate values.

How To Find Duplicates in Excel

Learning how to find duplicates in Excel isn’t a complex task — but it’s an important one. Excel provides several methods to locate duplicates, whether you’re highlighting them, filtering them out,

Read More »
Count unique values in Excel—Example spreadsheet

How To Count Unique Values in Excel

If you’re working with larger data sets, you’ll commonly encounter duplicates in your spreadsheets. This is the main reason you’ll have to count unique values in Excel. Luckily, Excel has

Read More »
Enter the Equal sign (=) and the COUNTIF function.

Can Excel Count Cells with Text?

Excel offers many ways to tackle any challenge, including the seemingly simple task of counting cells with text. Throughout this article, we’ll show you various strategies that you can use

Read More »

More Spreadsheet Expertise