Shopping Cart

Finding and dealing with Duplicates

Having Duplicates in your Data can be a real problem, so addressing them is important. Finding them, especially in a big data set, can often be an arduous task though.

A simple combination of Conditional Formatting with Filters is a great way to highlight and track down those Duplicates.

The basic steps are as follows:

  • Select a column that should be unique per record
  • From the Home Ribbon go to Conditional Formatting > Highlight Cell Rule > Duplicate Value…
  • Add Filters to your Data and select the Filter by Color option
  • To group your like Duplicates together, Sort your records by the same column
  • You can now Delete and / or Edit your Duplicates till you have no more coloured cells left

For more of these time-saving tips, as well as skills to help increase your productivity, be sure to check out our online Excel training courses, starting from beginner to expert.


Want to learn more?

Receive our Excel tips and news to your inbox!

"*" indicates required fields

This field is for validation purposes and should be left unchanged.

Request a Consultation

MS Excel Advanced Course

R 1,550

Course Length: 79 Lessons | 7.5 Hours of Videos

Content Covered

  • Key Essentials
  • Spreadsheet Integrity
  • Cell References
  • Forecasting
  • CSV Import
  • Merging Data
  • Splitting Data
  • Data Validation
  • Worksheet Protection
  • Advanced Formula
  • Text Formula
  • Date Formula
  • Logical Formula
  • Lookup Formula
  • Maths Formula
  • Pivot Tables & Charts
  • Excel Automation (Macros)

MS Excel Intermediate Course

R 1,350

Course Length: 55 Lessons | 5.5 Hours of Videos

Content Covered

  • Key Essentials
  • Series Generation
  • Advanced Copy and Paste
  • Formula
  • Cell Referencing
  • Rounding
  • View Optimization
  • Find and Replace
  • Sort and Filter
  • Graphs
  • Conditional Formatting
  • Ranges vs Tables
  • Pivot Tables
  • Data Manipulation
  • Keyboard Shortcuts
  • Tips and Tricks

MS Excel Beginner Course

R 1,150

Course Length: 56 Lessons | 4 Hours of Videos

Content Covered

  • Excel Overview
  • Key Essentials
  • Data Input
  • Excel Autofill
  • Formatting Cells
  • Number Formatting
  • Formatting Worksheets
  • Formulas
  • Printing
  • Basic Sort and Filter
  • Visualizing Data
  • Excel’s Golden Rule
  • Pivot Tables Sneak Peek
  • Keyboard Shortcuts
  • Tips and Tricks