Posts Tagged 'Excel duplicates'
Video: How to merge duplicate cells in Excel
Learn different ways you can combine unique values or sum numbers that refer to the same record in Excel Continue reading
Video: How to find and remove duplicates in Excel
See three simple ways you can find and remove duplicates in Excel: use standard functions, Conditional Formatting, or a special add-in. Continue reading
Video: How to compare two columns in Excel
There are quite a few ways you can find matches and differences between columns. We suggest trying one of three reliable methods described in this video any time you need to compare columns in the same or in different sheets. Continue reading
Distinct and unique values in Excel: how to find, filter, select and highlight
If you want to quickly find, filter and highlight unique or distinct values in your Excel worksheets, this tutorial will show you fast and efficient ways. Continue reading
How to remove duplicates in Excel (duplicate rows, values and partial matches)
The tutorial explains how to remove duplicates in Excel 2010, Excel 2013, and Excel 2016. You will learn a few different techniques to find and delete duplicate values with or without first occurrences, remove duplicate rows, detect absolute duplicates and partial matches. Continue reading
How to find duplicates in Excel: identify, highlight count, filter, and more
The tutorial explains how to search for duplicates in Excel. You will learn a few formulas to identify duplicate values or find duplicate rows with or without first occurrences. You will also learn how to count instances of each duplicate record individually and find the total number of dupes in a column, how to filter duplicates, and more. Continue reading
How to compare two columns in Excel for matches and differences
The tutorial demonstrates a number of techniques to compare and match two or more columns in Excel with formulas, conditional formatting and the specialized wizard. Continue reading
COUNTIF in Excel - count if not blank, greater than, duplicate or unique
The article explains Excel COUNTIF function, provides a number of examples and warns about possible quirks when using COUNTIF with multiple criteria and specific types of cells. Continue reading
How to prevent duplicates in a column in Excel
Today I'll tell you how to prevent duplicates from appearing in a column of your Excel worksheet. This tip works in Microsoft Excel 2013, 2010, 2007 and lower. Continue reading
How to automatically highlight duplicates in Excel once something has been typed
This article will show you how to avoid duplicates in your table columns using built-in Excel tools. The solution works for Excel 2013, 2010, 2007, and it will take you just a few minutes to apply it to your table. Continue reading
Video how to: consolidate duplicate rows keeping unique data only
Watch our 2 minute video to learn how you can quickly merge duplicate rows into one using Combine Rows Wizard add-in. Continue reading
How to compare two columns in Excel and delete duplicates (highlight, color, move)
It will take you about 10 minutes to read this article and in the next 5 minutes (or even faster if you choose the 2nd solution described in the article :) you will easily compare two Excel columns for duplicates and remove or highlight the found dupes. Okay, the countdown is started! Continue reading
Fuzzy Duplicate Finder for Excel: what's new?
Have you ever been overwhelmed by the number of misprints you need to correct in your Excel tables? This post looks at using the new features of Fuzzy Duplicate Finder add-in as an easy way of finding fuzzy duplicates and correcting typos in a couple of clicks... Continue reading
