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
Bookmarks