Hi

Could someone help me with this one (or just tell me it's not possible)?

I have figures in one column that I want the MAX value of but *only* if the value does not match the value in another corresponding column.

For example
COL 1/COL 2
4 / 3
6 / 6
5 / 7
2 / 1

The desired result of the above would be 5. It is the highest number in Col1 that does not match the number directly next to it in Col2. 6 is not the max because it matches the value directly next to it in Col2