select cells that are different in two columns in Excel

Q106. I have 2 sets of lists from 2 different reports - how can I select the cells with differences?

For example, I want to compare the names list from 2 reports. I have placed them side by side. I want to identify the difference in names.

excel select cells that are different in two columns

To do it in Excel, here is the answer:

a) Select the 2 lists, press F5 and in the "Go To" dialog that pops up, click on "Special" (Alternatively, click on "Find & Select" under "Home". Click on "Go To Special").

excel excel select cells that are different in two columns

b) In the "Go To Special" dialog box, click on "Row differences", click OK.

excel excel excel select cells that are different in two columns

c) All the cells that have different values for the same rows are highlighted.

excel excel excel excel select cells that are different in two columns

d) Same comparison could be applied across columns by selecting "Column differences" in the "Go To Special" dialog box.

 

You can find similar Excel Questions and Answer hereunder

1) How can I get users to select a folder to save the output of my macro?

2) How can I find the number of working days between 2 dates using VBA?

3) Split one long column into multiple smaller columns in Excel

4) How can I sort data using VBA?

5) how to combine the content of two or more cells in Excel

6) Split string into multiple columns in Excel

7) How can I clear all formats (formats alone not data) from a range of cells?

8) How can I enter information in multiple cells simultaneously?

9) I have read that Merging cells should be avoided if possible. In Excel, how can I then make my Title appear in the center of my Data Table?

10) I have a complex WorkSheet with lot of fields and data - How can I quickly find the cells that have formulas?

11) How can I plot 2 series on the same chart with different scales / measurement unit for Values (Ex: Pareto chart)?

12) Applying a countif formula only to visible cells in a filtered list in Excel

13) I have a column header Title that is big - I cannot increase the size of column. In Excel, how can I somehow fit the Title retaining the existing column width?

14) How do I add a symbol like Triangle / Inverted Triangle for indicating trends in a cell using VBA?

15) How can I identify cells with Circular Reference in a WorkSheet?