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

den 0
Viewed 25

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: https://i.stack.imgur.com/jEIkV.png

formula excel-formula function excel
2 Answers

Use below formula-

=TEXTJOIN(", ",TRUE,FILTER(ADDRESS(ROW(A4:A8),1,4),B4:B8=A1))

enter image description here

Harun24hr0

What about this approach:

Screenshot:

enter image description here

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) :-)

Dominique0
Related