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.

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.

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 ...

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 ...

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 ...