Excel - Find & Highlight Duplicate Rows - 3 Methods | Conditional Formatting
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 https://drive.google.com/file/d/1mKY5...
And make sure you subscribe to my channel!
- EQUIPMENT USED --------------------------------
○ My camera – https://amzn.to/3vdgF5E
○ Microphone - https://amzn.to/3gphDXh
○ Camera tripod – https://amzn.to/3veN6Rg
○ Studio lights - https://amzn.to/3vaxyy5
○ Dual monitor mount stand - https://amzn.to/3vbZSjJ
○ Web camera – https://amzn.to/2Tg75Sn
○ Shock mount - https://amzn.to/3g96FGj
○ Boom Arm - https://amzn.to/3g8cNi6
- SOFTWARE USED --------------------------------
○ Screen recording – Camtasia – https://chrismenardtraining.com/camtasia
○ Screenshots – Snagit – https://chrismenardtraining.com/snagit
○ YouTube keyword search – TubeBuddy – https://www.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!
Watch video Excel - Find & Highlight Duplicate Rows - 3 Methods | Conditional Formatting online without registration, duration hours minute second in high quality. This video was added by user Chris Menard 01 September 2021, don't forget to share it with your friends and acquaintances, it has been viewed on our site 92,48 once and liked it 74 people.