Excel Compare two columns of infinite ROWS

Excel Compare two columns

Suppose there is data of 50-100 rows or more in two columns, A and B
you want to compare whether they are equal or not

---------------------------------------------------------------
column A        || column B           || column C
----------------------------------------------------------------
100                      101                    =IF(A1=B1,0,1)
---------------------------------------------------------------


you can type in column c1, this formula
=IF(A1=B1,0,1)
press enter

Result is 0 if content of A1 CELL and B1 CELL values are same
Result is 1 if content of A1 CELL and B1 CELL values are NOT same

Now, you copy C1 cell and paste in the remaining 49or 99 rows down
so that you would see the result for all 49 or 99 rows in the excel worksheet having data.