I'm trying to write a formula for my excel document to do the following:
If the cell contains text, return nothing and continue the search in the cell below.
If the cell does not contain text, return '1' . Then, move to the next cell and continue search.
Here's an example of what I want it to look like.

Issue.jpg