Name: How to find duplicates in Excel
Uploaded: 2023-03-05T15:51:26.000Z
Duration: 16 s

In this Excel tip, we're going to learn how to compare lists in Excel using a hack. This hack will allow us to find out who is on both lists, meaning we'll be able to identify who is on both the original list and the second list. This is how to find and highlight the duplicates.

Knowing who is on both lists can be helpful in a variety of situations, such as order processing or customer management. If you're interested in learning this excel hack, then be sure to watch the video!

Microsoft Excel

I'm a Microsoft MVP, the Chief Operating Officer at OnTheClock, an employee time tracking software, with an MBA from Macquarie University and have an extensive background in analyzing and solving problems. 

I've worked in automotive, biotech, pharmaceuticals, luxury consumer goods and now SaaS. Let me show you how to incorporate Excel into your work to make it easier and actionable. 

How to find duplicates in Excel

2bf2255c-05e8:37755;isclassifiedstrendingsuggestionsenableddt:42136;316f64c0-2415:46048;b2454379-d6cf:44572;335d7519-3303:46159;31885555-099a:47313;1a645375-144d:47316;jgfi9803:61686;ei83g319:53872;596id705:58363;fg008402:58376;i6jj6667:86739;istutorredesignv2_1:73124;a5gbd220:61179;blogpwt:71359;5db3b892:67466;2a2j8400:70238;b534g232:70741;j91hb444:69773;18h21436:69961;85h98405:81245;0eie7335:76839;cia78296:75037;9b4gd804:78753;deisn977:110326;1d789912:110325;slcardst:87990;searchranking_newpqs:91321;b1ff5649:88417;d9c7i206:87231;ajgj0920:88926;a1d06430:92612;4fh22297:92227;3cf2h499:95552;90ahj157:94513;2a718373:100011;gg41j822:94817;3i5dg498:97157;437bb176:97771;241d3193:100431;9ab7j510:99496;86afb588:101093;bfb37872:105751;7f8gg909:114000;eh7a9388:114646;

Beginner

Intermediate

Advanced

Chief Operating Officer

I take complex frameworks, formulas and concepts and simplify them to apply to real-life business cases to solve problems. 

I have about 300k followers learning Excel and Sheets tips and tricks on various social platforms.

Editor and Founder

English

Quick, concise lessons in manageable chunks to make it easy to learn.

How to create a step chart with Excel

Show the actual, budget, and forecast values in an Excel stacked bar chart.

Excel actual, budget, forecast chart tutorial

Learn how to create a more advanced Gantt Chart to track project milestone progress.

Excel Gantt Chart Tutorial

Learn how to create this KPI chart using icons in Excel.

Excel KPI scorecard chart tutorial

Excel fishbone Ishikawa Diagram Tutorial

Excel color changing status

Excel dashboard with donut chart and progress bars

Excel dashboard tutorial with navigation bar

Excel color scale rank chart tutorial

Learn how to create progress bars that change color based on value you set for things like sales and satisfaction comparison.

Learn how to create this circular bullet chart to show something like satisfaction or service level in Excel.

Excel circular bullet chart tutorial

Learn how to create a slightly more advanced bar chart than the default.

Nicole H.

How to find duplicates in Excel

Nicole's Microsoft Excel videos

How to create a step chart with Excel

Excel actual, budget, forecast chart tutorial

Excel Gantt Chart Tutorial

Excel KPI scorecard chart tutorial

Excel fishbone Ishikawa Diagram Tutorial

Excel color changing status

Excel dashboard with donut chart and progress bars

Excel dashboard tutorial with navigation bar

Excel color scale rank chart tutorial

Excel color changing status

Excel circular bullet chart tutorial

Excel advanced bar chart tutorial

Teacher Reviews

Book online lesson

How to Use RANK Function in Microsoft Excel

How to Use ROW Function in Microsoft Excel

Active Rows and Columns Highlighter in Microsoft Excel

How to Take Screenshot Using Microsoft Excel In-Built Camera

How to Use VSTACK Function in Microsoft Excel

How to Insert a Empty Row After Each Row in Microsoft Excel

How to create a step chart with Excel

Excel actual, budget, forecast chart tutorial

How to Create Folders for the List of Names using Microsoft Excel

How to Remove Spaces in Words In Microsoft Excel

Related Subjects