Columns in Excel using a formula to compare
No matter whether your values are Numbers or terms, you can use the following method:
- In the column next to the two that you want to compare, enter in addition to the top-filled-in field, use the following formula: "=IF(A1=B1;"identical";"non-identical")"
- Instead of A1 and B1, type the first two to be compared cells.
- Copy the formula into the entire column by clicking the cell in the lower right corner with the mouse and drag down.
Columns in Excel to compare: the difference
If you Pay your size to compare want, you can do that with a simple difference.
- Enter in the top field next to the to be compared the formula "=A1-B1, the columns".
- Instead of A1 and B1, enter the first two cells you want to compare.
- In the case of the same values you get as a result 0. Otherwise, you get a positive or a negative number.
- You will have to copy the formula into the entire column by dragging the cell to the bottom right corner with the mouse to the bottom.

Columns in Excel to compare
Video tip: the column in Excel to show
The comparison still more vivid, you can with conditional formatting to work.