Hello,
I am trying to come up with a formula that returns the specific ROW in a range where either Column A = "FALSE" or ISBLANK AND Column B = ISBLANK.
This new formula would appear in C1.
GOAL - This formula will help me determine the first row in the range that needs attention. If there are subsequent rows, the formula would automatically update after said row is fixed.
TIA
-J
I am trying to come up with a formula that returns the specific ROW in a range where either Column A = "FALSE" or ISBLANK AND Column B = ISBLANK.
This new formula would appear in C1.
GOAL - This formula will help me determine the first row in the range that needs attention. If there are subsequent rows, the formula would automatically update after said row is fixed.
TIA
-J
Last edited: