I have three columns. "Site ID" with a value, "Ready" with date and "Installation Completed" with date.
Now I want that I search whole column B for non-blank cell, if I found then it checks column C is blank, if column B is blank then write value of Column A in Column D where I am writing formula otherwise move to search for next non-blank value in Column B.
Hope you understand and help me with solution.