Hi,

I have multiple tables (dynamic range)  in the same sheet and want to compare them with tables in another sheet.

Please let me know how to do this.

Regards,

Sateesh

Could you elaborate on which type of differences are you trying to detect? What is the output you would ideally get from the comparison?

Do you expect cell XY in worksheet A to be equal to cell XY in worksheet B?
If this is the case, I would create a third worksheet and write on cell A1 this formula (assuming your worksheets are called "worksheet A" and "worksheet B"):

=if('worksheet A'!A1='worksheet B'!A1, "", "mismatch")

Now you can copy A1 formula to the desired range in the third worksheet, and find the mismatching values.

• Edited by Gil RavivMicrosoft employee 16 hours 44 minutes ago

Could you elaborate on which type of differences are you trying to detect? What is the output you would ideally get from the comparison?

Do you expect cell XY in worksheet A to be equal to cell XY in worksheet B?
If this is the case, I would create a third worksheet and write on cell A1 this formula (assuming your worksheets are called "worksheet A" and "worksheet B"):

=if('worksheet A'!A1='worksheet B'!A1, "", "mismatch")

Now you can copy A1 formula to the desired range in the third worksheet, and find the mismatching values.

• Edited by Gil RavivMicrosoft employee Friday, March 13, 2015 2:40 PM