Compare Data

Excel split screen - view different parts of a sheet at once

When working with large datasets, it can be helpful to see a few areas of the same worksheet at a time to compare different subsets of data. This can be done by using Excel's Split Screen feature. Continue reading

How to open Excel files in separate windows and multiple instances

Having spreadsheets in two different windows makes many Excel tasks easier. One of the possible solutions is viewing workbooks side by side, but this eats a lot of space and isn't always the best option. Continue reading

VLOOKUP to compare two columns in Excel for common values and missing data

When you have data in two different lists, you may often need to compare them to see what information is missing in one of the lists or what data is present in both. Comparison can be done in many different ways, which method to use depends on exactly what you want from it. Continue reading

The Compare Sheets tool for Excel is out!

I am happy to let you know that the Compare Sheets tool is finally out! You can find it in Ablebits Ultimate Suite for Excel 2018.3. Continue reading

How to compare two Excel files for differences

In this video you will learn 4 ways you can find differences in excel tables: view files side by side, use formulas or conditional formatting to see updates, Compare and Merge shared spreadsheets, and see a special add-in for comparing two Excel files. Continue reading

How to compare two cells in Excel (string comparison)

While Excel formulas are always perfectly true, their results may be wrong because some flawed data penetrated into the system. This tutorial will teach you how to automate the tedious and error-prone task of cell comparison and what formulas are best to use in each particular case. 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

Synkronizer - your easy way to compare Excel files

In this article you'll see how to compare two Excel files with the help of the Synkronizer tool. Continue reading

How to compare two Excel files for differences

Learn a variety of methods to compare Excel files and identify differences between them. See how to open two Excel windows side by side, how to use Excel formulas to create a difference report, highlight differences with conditional formatting, 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

Excel logical operators: equal to, not equal to, greater than, less than

Many tasks you perform in Excel involve comparing data in different cells. For this, Microsoft Excel provides six logical operators, which are also called comparison operators. This tutorial aims to help you understand the insight of Excel logical operators and write the most efficient formulas for your data analysis. 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

View two or more Excel sheets side by side

When it comes to comparing worksheets in Excel, the most obvious solution is to place tabs side by side. Luckily, it's as easy as it appears to be :) Continue reading

Ukraine flag War in Ukraine! To support Ukraine and save lives please visit this page.