Highlight and Count Duplicates in Row - Excel Tutorial

In this video, we handle duplicates in a row in Excel. We will cover how to highlight duplicates and count duplicates in rows in all versions of Excel. The video shows the duplicate rule of Conditional Formatting. It is helpful, but not up to the task we need a solution for. So, a formula is created using COUNTIFS to highlight duplicates and is then applied to a Conditional Formatting rule. Then two Excel formulas are shown to count duplicates in row. One for Excel 365 and another for all Excel versions. This video describes the SUMPRODUCT solution to count duplicate values - https://youtu.be/x216dW2x5Gs The timings of the video. 00:00 - Duplicate values with Conditional Formatting 01:42 - Duplicate values rule is not good enough 02:15 - Formula to identify duplicate names 04: 39 - Highlight duplicates in a row 05:53 - Count duplicates in row (Excel 365) 08:13 - Count duplicates in row (All Excel versions) Find more great free tutorials at; https://www.computergaga.com