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/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!
Видео Excel - Find & Highlight Duplicate Rows - 3 Methods | Conditional Formatting канала Chris Menard
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!
Видео Excel - Find & Highlight Duplicate Rows - 3 Methods | Conditional Formatting канала Chris Menard
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
Excel - Scenario Manager / What-if AnalysisExcel Essential Skills | Rows & Columns and the EVIL Merge and CenterQuick Analysis in Excel - Charts, Totals, Running Totals, Data Bars, and Sparklines by Chris MenardGetting started with PowerPoint Animations by Chris MenardWhat is VPN and Why Do You Need It?OneDrive - Teams and Outlook folders automatically created in OneDriveExcel for the web - Recommended Pivot Tables - New Feature 2021Excel Charts - 5 COOL TIPSTeams improvement to screen sharingExcel Filtering Tips with Chris Menard - Microsoft Certified TrainerTeams Video Call or Meeting - Toggle View - Teams TipPowerPoint Hyperlinks - Create, Edit, and used Advanced Hyperlinks by Chris MenardExcel - using the Scenario Manager to track house payments with skyrocketing mortgage rates.Getting started with ChatGPT - Three ExamplesExcel - Getting started with Filtering DataExcel 3D Reference - easily reference data on another worksheetMicrosoft Teams new sharing experience for Meetings and Video Chat - May 2021Excel - Save a Chart as an Image to use in PowerPoint, Teams, LinkedIn or other appsSORT Function using Excel for the Web by Chris MenardCopilot: Summarize Emails, Chats, and Files with Others In SECONDSMicrosoft Forms - Share Responses for Surveys and Polls