Formula tool for comparison.

Question

Hey guys,

Does anyone has any idea of using formula tool for comparison between 2 different worksheets in 1 workbook. A column by column comparison (12 columns, some consist strings, some numbers) and report/separate any changes. 1st column is primary key and rest columns need to be compared.

I have done it using transpose and crosstabs but got the feedback to try using formula tool if number of columns to be compared < 20. Will be shorter that way.

Thanks

binu_acs · Accepted Answer

@ShantanuDagar Transpose and cross tab is the dynamic way of doing this.

gautiergodard · Accepted Answer

Hey @ShantanuDagar

I would agree with @binu_acs - sounds like you are already approaching this problem in the right way.

Formulas will present you with a limitation as you will not be able to dynamically compare new columns entering your dataset.