Thanks to all that help or try to help.
I am trying to write a formula to check two cells in adjacent rows and give a result depending on what is in another cell. Please see attachment for an example. Basically what I need in column J is
IF B3=B4 and I3 or I4 is >0, if its true 1, false 0
I would like the result to show in both rows in column J. The desired results are in red on the sample sheet
Many thanks to those who help.
Bookmarks