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
Solved! Go to Solution.
@ShantanuDagar Transpose and cross tab is the dynamic way of doing this.
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.