I have a small range of cells that contain the text either "Pass", "Fail" or "Not Run". Here's an example:
E10: Pass
E11: Pass
E12: Pass
E13: Fail
Another example is:
E10: Pass
E11: Pass
E12: Not Run
The next row below the "Fail" or "Not Run" is always a blank and in E9 I need a formula that will return the last row result before the blank cell.
Many thanks
Bookmarks