How to Compare multiple Column wihtout using dedundant If Else statement

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

Sample Data.xlsx

Data Investigation

Accepted answers

JamesCharnley

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.