How to Compare 2 Columns

Karen575 

Compare two columns quickly

In this tip, we will show you how two columns can be compared quickly and easily with one another without much detour.

Column A and column B serve as the starting point.

In order to determine the cells in column B that differ from column A, simply proceed as follows:

Select cell range A2: B9 (as an example)

Use the function key [F5] or the key combination [Ctrl] + [G] to open the Go to dialog box

Click the Contents button to open the Select Contents dialog box

Activate the Cell differences option there.

If you now exit the dialog box by clicking the OK button, Excel will mark all cells in column B that differ from column A.

If, for example, you change the font or background color of the selected lines, you will always see which cells do not match.

 However, this function does not differentiate between upper and lower case. However, spaces are taken into account when determining the differences.

It's even easier when there are numbers.

Comparison between A and B column if there are numbers, einach = A1-B1 in column C. If no zero then not equal.

But if you have done business at the end of my execution, here is a formula for your request.

=IF(A2=B2;"OK";"error")

Also attached is the file with the test.

Hope ... I'm almost certain that this will work on your mac too ... even if I don't have one to try it out.

I would be happy to know if I could help.

Nikolino

I know I don't know anything (Socrates)

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.