How to check two columns are equal in excel?
1 answer(s)
It is a simple trick. You can make a new column, for example column C.
In the first cell, C1, you just type this formula: =A1=B1. This will check if the first row is the same. It will show TRUE if they match. It will show FALSE if they do not match.
After that, you click the little square on the corner of cell C1. Drag it all the way down. This will copy the check for all of your rows.
If you want words, you can use =IF(A1=B1, "Match", "No Match") instead.
Hope this helps you.