Posts Tagged 'Excel duplicates'

Sep
15

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

Jun
7

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

May
19

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

Apr
13

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

Mar
16

How to remove duplicate values and rows in Excel

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

Mar
2

How to identify duplicates in Excel: find, 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

Aug
26

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

Jul
2

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

Oct
20

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

Sep
13

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

Excel add-ins and Outlook tools - Ablebits.com
Ultimate Suite for Excel Professionals
 
 
50+ professional tools for Excel 2016-2007 to do your daily work
Incredible product, even better tech support…AbleBits totally delivers!
Deborah Bryant
Anyone who works with Excel is sure to find their work made easier
Jackie Lee
The best spent money on software I've ever spent!
Patrick Raugh
Ablebits is a fantastic product - easy to use and so efficient.
Debra Celmer
Excel is at its best now
Annie C.
I don't know how to thank you enough for your Excel add-ins
Jennifer Morningstar
Anybody who experiences it, is bound to love it!
Kumar Nepa
AbleBits suite has really helped me when I was in a crunch!
Nelda Fink
I have enjoyed every bit of it and time am using it
Christian Onyekachi Nwosu
It's the best $100 we've ever spent!
Mike Cavanagh
I love the program, and I can't imagine using Excel without it!
Robert Madsen
One word… WOW!
Dave Brown
Love the products!
David Johnston
It is like having an expert at my shoulder helping me…
Linda Shakespeare
Your software really helps make my job easier
Jeannie C.
Thanks for a terrific product that is worth every single cent!
Dianne Young
I love your product
Brad Gibson
Awesome!!!
Sheila Blanchard
 
 
Older posts →