need Help !! Multi row formula

[Rakesh_Jasuja]

Hi All,

I have dataset where I need to compare 1st row with 3rd row. I am trying to compare it with using row+1 = Row-1 but it is not giving expected results. can anyone help please?

here is an example

2022

2020

2022

output should be true if row 1 (2022) and row 3 (2022) have same value.

This is part of dataset and as per the requirements I have to use data as it is, and I don't have to sort it.

[JosephSerpis]

Hi @Rakesh_Jasuja had to create a new column and then rename it to achieve the output you desire.

[Rakesh_Jasuja]

Hi @JosephSerpis  thank you so much for sending the workflow.

this seems to be working, however there are 24 column  where this need to be applied, also I need to test this out in actual data. Which includes additional scenarios.

I will make those changes during weekend and will reply once it is working.

Thank you so much for your help.