How to Compare multiple Column wihtout using dedundant If Else statement

[Gsiva3]

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

[DataNath]

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:

[JamesCharnley · Accepted solution]

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.

[Gsiva3]

@JamesCharnley 

Thanks for the workflow.

It worked!!

[Gsiva3]

Hi @DataNath 

Its wokring. But my condition is the next row will not always end with 1