I'm not even sure if this is possible. You are brilliant if you can do it!
I have a spreadsheet that contains test cases. Column A has an ID for every separate test case. If column A has an ID (other cells will be blank) then look at all values for that test case and input the status.
It will look like this:
Column A has the value of 1 on row 15 and the value of 2 on row 20.
Column F has the text Pass, Fail, Skipped or Blocked or blank in the rows 16-19. These values are also stored as 1 if true in columns G - K ; meaning column G will have a 1 if the step passed, H will have a 1 if it is failed, J will have a 1 if blocked, and K will have a 1 if skipped.
I need to look at the values and if any step fails, place a 1 in Column F of the same row that contains the ID - row 15. If all steps pass, then a 1 will be placed in column H of row 15.
I've attached a spreadsheet to help explain.