I have a complex problem. I hope I can find a solution here.
I have a range of sample data in columns A:G. I want to create a representation of this data in columns I:O like this:
Each cell of every row is compared with the next 5 rows. If the value of the cell or +1/-1 value of the cell is...