IF statement help!

[THE LEGEND x7x]

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

[benishiryo]

hi there, welcome to the forum. assuming your data is in column A1:B7 like in the picture, try this in D2:
=IF(E2="","",1)

and this array formula in E2:
=IF(COUNTIF($B$2:$B$7,"")>=ROW(1:1),INDEX($A$2:$A$7,SMALL(IF($B$2:$B$7="",ROW($B$2:$B$7)-1),ROW(1:1))),"")
for this, you have to paste the formula inside the formula bar & press CTRL + SHIFT + ENTER

[THE LEGEND x7x]

Wow!.. That is amazing. Thank you soo much!

[dogberry]

Hi

Judging by your comment your problem has been solved, can you help the mods out by marking it as solved.

Chris