Check 2 columns in the same sheet.

  • Thread starter Thread starter Abhiram
  • Start date Start date
A

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
 
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.
Click to expand...

=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.
 
Back
Top