Forum Discussion
How to Compare 2 Columns
- Nov 30, 2020
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.
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.
- Karen575Nov 30, 2020Copper ContributorWorked like a charm, thx, Nikolino!!
- NikolinoDENov 30, 2020Platinum ContributorYou are welcome
I was pleased to be able to help you.
Nikolino
I know I don't know anything (Socrates)