Identify Duplicates in Your Data Without Removing Them | MS Excel скачать в хорошем качестве

Identify Duplicates in Your Data Without Removing Them | MS Excel

Identifying duplicate values in your data - in place, without removing them - is a first step to cleaning, reconciling, and otherwise inspecting your data so you can understand and answer questions about your data. In this video, I review three different approaches - manual review, conditional formatting, and helper columns - and discuss some pros and cons of each. Contents of this Video - 00:00 Introduction 00:53 Manually review data for duplicates 01:16 Sort to find duplicates in data 02:37 Use the filter to identify duplicates in data 03:32 Conditional formatting to identify duplicates in data 04:57 Find duplicates in a single column and identify with conditional formatting 05:08 Highight duplicate values in data with Excel's built-in conditional formatting 05:39 Use a formula with conditional formatting 07:51 How to modify a conditional formatting rule 08:30 Find duplicates in multiple columns and highlight with conditional formatting 11:09 Filter table data by cell fill color or font color 11:22 Use helper column to identify duplicate data 11:55 Find duplicates in a single column using a helper column formula 13:28 Find duplicates across multiple columns using a helper column formula 16:47 Find the Nth instance of a value in sorted data 19:37 Let's connect! If you'd like help with your data projects, or training for you and your team, let's connect at: https://BlouDesigns.com - learn more about how I help businesses and schedule a Zoom chat   / barbara-olsafsky   - follow and/or DM me for more on SOPs, Data Strategy (including working with data in Excel), and aligning your efforts with your goals Subscribe to this channel:    / @bloudesigns   Behind the scenes: Video Editing with Techsmith's Camtasia (plus some screen captures): https://techsmith.z6rjha.net/YgjBNJ Recording with (free) OBS Studio (humans and some screen captures): https://obsproject.com/ Note: This description contains affiliate links, which means that at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support! --- All product and company names are trademarks or registered trademarks of their respective holders. Use of them does not imply any affiliation with or endorsement by them.