Hellow guys, Welcome to my website, and you are watching Excel - Find & Highlight Duplicate Rows - 3 Methods | Conditional Formatting. and this vIdeo is uploaded by Chris Menard at 2021-09-01T06:08:27-07:00. We are pramote this video only for entertainment and educational perpose only. So, I hop you like our website.
| Name | Excel - Find & Highlight Duplicate Rows - 3 Methods | Conditional Formatting |
| Video Uploader | Video From Chris Menard |
| Upload Date | This Video Uploaded At 01-09-2021 09:08:27 |
| Video Discription | 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/1mKY5uRPKqNvUfGAPJWdvb18Se1zbqB8z/view?usp=drivesdk 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! |
| Category | Education |
| Tags | conditional formatting | highlight duplicates | highlight duplicates in excel | duplicate rows in excel | find duplicate rows | countifs in excel | textjoin function | textjoin formula excel | concatentate function | concatenate excel | concatenate formula in excel | duplicate values conditional formatting | chris menard | chris menard excel | chris menard training | find duplicates in excel | duplicate values | microsoft excel |
