Formula where it shows the cell location for certain words in the list but with blanks.

Is there a formula where if I have a list, for example, "Ready For Work" it will write down the cell location into 1 cell, but only if there is no one working on it (blank name) so that I can find the work easily?

My Formula I have so far is "=TEXTJOIN(", ",TRUE,FILTER(ADDRESS(ROW(D:D),4,4),F:F=D1),)"

All I'm missing is the IFBLANK formula, but don't know how to implement it.

What I have so far:

CodePudding user response：

What about this approach:

Screenshot:

Used formulae:

=IF(B2="a b c",ROW(),"")
=IF(NOT(C2=""),"B","")
=D2&C2
=TEXTJOIN(",",TRUE,E2:E7)

(I would give some explanation, but it's self-explaining, I guess) :-)