The Excel IF() function returns “Duplicate,” when the Excel function, COUNTIF() finds more than one occurrence of the concatenated values in column H. Figure F Image: Susan Harkins/TechRepublic.

Double-click the Excel icon and click the "File" tab. Browse to and double-click the workbook to open it. If you are using dual monitors, drag the window onto the second screen.

Fortunately, thanks to Excel’s FILTER() dynamic array function, creating a list of duplicate values is easier than it once was. In this article, I’ll show you how to use FILTER() to create a ...

Open your first instance of Excel, and then right-click the Excel tile on the Start screen. Hold down the "Alt" key and click "Open New Window" on the Start screen taskbar.

The New Window tool lets you do just this. Here's how to use it. I'm going to use Microsoft Word to show you how to use this ...

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.

How do I open Apple Numbers in Excel in Windows? When the Numbers file is open, go to the spanner icon in the upper right area of the screen. Click this, and a drop down menu will appear.

Keeping a count of the number of duplicate entries across a column in Excel is very useful for many reasons. The first is to check for duplication, then for entries where duplication is intended ...

Whether you've earned a data-related job promotion or recently learned some new Microsoft Excel skills, take the How-To Geek Intermediate Excel Test to put your expertise under the microscope! This is ...