Check 2 columns in the same sheet.

[Abhiram]

Hi,
Can someone suggest me if there is any function in
Excel with which i can compare 2 columns?? I dont want to
write lengthy code.
Actually i am running a macro on an Excel sheet. The
output i want to check if its accurate. So i cut and
paste the original data in one column of the sheet and
quickly cross chk if all the rows of the column match
with the output from MAcro.
Precisely I need to compare Data from 2 Columns in the
same sheet and chk if anywhere the data is dissimilar.

I would appreciate any help.
Thanks,
Abhiram

 

[Harlan Grove]

Can someone suggest me if there is any function in
Excel with which i can compare 2 columns?? I dont want to
write lengthy code.
Actually i am running a macro on an Excel sheet. The
output i want to check if its accurate. So i cut and
paste the original data in one column of the sheet and
quickly cross chk if all the rows of the column match
with the output from MAcro.
Precisely I need to compare Data from 2 Columns in the
same sheet and chk if anywhere the data is dissimilar.

=AND(B2:B99=C2:C99) or =OR(B2:B99<>C2:C99)

The first returns FALSE and the second returns TRUE if there are any differences
between corresponding values in the two same size, same shape ranges.