Microsoft Excel can find duplicates easily with Conditional Formatting. The issue is Conditional Formatting finds duplicates based on the cell value, but I want to find duplicate rows. I use three methods in the video to find duplicate rows. I start off with CONCATENATE, then use the TEXTJOIN function, and finally COUNTIFS with no helper column. To highlight the rows I use Conditional Formatting using a formula.
Chapters:
00:00 Introduction
00:14 Duplicate cells
00:58 Conditional formatting works on cells
01:49 Method 1 - Concatenate
02:39 Method 2 - TEXTJOIN
03:47 Conditional formatting entire row
05:23 Method 3 - COUNTIFS with no helper column
06:14 Closing remarks
CONCATENTATE in Excel
Use CONCATENATE, one of the text functions, to join two or more text strings into one string. You can use an ampersand also. Example: cell A2 has Chris and cell B2 contains Menard. =a2&" "&B2 will return Chris Menard in cells C2. Same for row 3. In cell C3, could use =CONCATENTATE(A3," ",B3) to get Chris Menard
Screenshot of the example above drive.google.com/file/d/1mKY5uRPKqNvUfGAPJWdvb18Se1zbqB8z/view?usp=drivesdk
And make sure you subscribe to my channel!
-- EQUIPMENT USED ---------------------------------
○ My camera – amzn.to/3vdgF5E
○ Microphone - amzn.to/3gphDXh
○ Camera tripod – amzn.to/3veN6Rg
○ Studio lights - amzn.to/3vaxyy5
○ Dual monitor mount stand - amzn.to/3vbZSjJ
○ Web camera – amzn.to/2Tg75Sn
○ Shock mount - amzn.to/3g96FGj
○ Boom Arm - amzn.to/3g8cNi6
-- SOFTWARE USED ---------------------------------
○ Screen recording – Camtasia – chrismenardtraining.com/camtasia
○ Screenshots – Snagit – chrismenardtraining.com/snagit
○ YouTube keyword search – TubeBuddy – tubebuddy.com/chrismenard
DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!
- Excel - Find & Highlight Duplicate Rows - 3 Methods | Conditional Formatting ( Download)
- How to Find Duplicates in Excel & Highlight Duplicates If You Need To ( Download)
- Excel - Conditional Formatting find duplicates on two worksheets by Chris Menard ( Download)
- Highlight and Count Duplicate Rows In Excel | Highlight Duplicate Rows in Excel Except First ( Download)
- How to highlight duplicate rows across Multiple columns in Excel ( Download)
- Find & Highlight Duplicate Rows | Find Duplicate Value Using CONDITIONAl FORMATTING ( Download)
- Highlight Duplicates in Excel in Same Column in a Different Colour ( Download)
- Three EASY Ways to Find and Remove Duplicates in Excel ( Download)
- How To Highlight Duplicates In Excel | How To Find Duplicate Records In Excel | Simplilearn ( Download)
- How to Find Duplicates in Excel | 3 Ways to Highlight Duplicates in Excel ( Download)
- Excel Highlight Every Nth Row with Conditional Formatting - Every 3rd, 4th, or 5th row. ( Download)
- Find & Highlight Duplicates Across Multiple Columns Using Conditional Formatting ( Download)
- Remove Duplicates in Excel (3 Methods) ( Download)
- Compare Two Excel Worksheets & Find Duplicates Using Formula or Conditional Formatting ( Download)
- How To Highlight Duplicates in excel | Conditional Formatting in Excel Color coding | #msexcel ( Download)
