Is there a shorter / more efficient formula for doing than like this?:
I'm flagging if there's a an entry in a cell in one row, but nothing in the corresponding cell in the same column in the next row.
Excel Formula:
=IF(OR(AND(C7<>"",C8=""), AND(C9<>"",C10=""), AND(C11<>"",C12="")), "Check!","Carry on")
I'm flagging if there's a an entry in a cell in one row, but nothing in the corresponding cell in the same column in the next row.