How To Compare Two Columns in Excel

158

This tip is about the how To Compare Two Columns in Excel. So read this free guide, How To Compare Two Columns in Excel step by step. If you have query related to same article you may contact us.

How To Compare Two Columns in Excel – Guide

When you’re working with information in Excel, you sometimes have to think about the information. This can be seen in two sections or even information in multiple sheets / workbooks. In this Excel tutorial, I’m going to show you several strategies for thinking about two segments in Excel and looking for matches or contrasts. There are several ways to do this in Excel and in this tutorial exercise I’m going to show you some of them (like comparing using VLOOKUP formula or IF recipe or conditional formatting on the other hand).

Microsoft Excel for Office 365

Open the Excel spreadsheet containing the data you would like to compare.

Select all cells in both columns that contain the data to be compared.

How to select one or more cells in a spreadsheet program.

On the ribbon, on the Home tab, find the edit section and click Find & Select.

From the drop-down menu, select Go to Special.

No pop-up Go To Special-up window, click Line Differences, and then click OK. Excel picks up differences between the two columns.

To highlight these differences, leave them selected, click the paint bucket icon in the font menu, and select the color you want to use. Likewise, you can right click and select the paint bucket to highlight the cells.

Microsoft Excel 2007 and 2010

Open the Excel spreadsheet containing the data you would like to compare.

Select all cells in both columns that contain the data to be compared.

How to select one or more cells in a spreadsheet program.

On the ribbon, on the Home tab, go to Find and select and click Go to.

In pop Go To-up window, click Line Differences, and then click OK. Excel selects the difference between the two columns.

To highlight these differences, leave them selected, click the paint bucket icon in the font menu, and select the color you want to use. Likewise, you can right click and select the paint bucket to highlight the cells.

Microsoft Excel 2003

Open the Excel spreadsheet containing the data you would like to compare.

Select all cells in both columns that contain the data to be compared.

How to select one or more cells in a spreadsheet program.

From the file menu at the top of the program window, click Edit and select Go To.

No pop-up Go To Special-up window, click Line Differences, and then click OK. Excel selects the difference between the two columns.

To highlight these differences, leave them selected, click the paint bucket icon in the font menu, and select the color you want to use. Likewise, you can right click and select the paint bucket to highlight the cells.

Final note

I hope you like the guide How To Compare Two Columns in Excel. In case if you have any query regards this article you may ask us. Also, please share your love by sharing this article with your friends.