Hi Team,
I have around 200 columns in which 100 columns have to be compared with another 100 columns. I know we can simply use if else in formula to find the differnce between 2 columns. But here I have 100 columns to be compared which will take more time to setup if esle formula. Is there any solution for this comparison. Can anyone help me on this. I have attached the sample data
Solved! Go to Solution.
Hi @Gsiva3, will these columns always be named like this i.e. A vs A1, B vs B1? If so, something like this ought to work and be fully dynamic:
Hi @Gsiva3
Generally to avoid statements like this we can pivot data to be able to dynamically reference up and down rows instead. My solution looks to pivot the table and group it into twos to only compare between the next row, check whether it's the same, and pivot back.
Hi @DataNath
Its wokring. But my condition is the next row will not always end with 1