Formula tool for comparison.

[ShantanuDagar]

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

[binuacs · Accepted solution]

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

[gautiergodard · Accepted solution]

Hey @ShantanuDagar 

I would agree with @binuacs - 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.