Forum Discussion
Excel Formuła Multiple Building selections, Consolidated in one Cell
So I am at a loss of what forumla to use. I have sent out a spreadsheet to my team that has 5 different buildings. I put the building names as the column header at top. If those individuals selected ...
Something like this?
= LET(
accessRequired, IF(access = "x", building, ""),
BYROW(
accessRequired,
LAMBDA(emplAccess, TEXTJOIN(", ", , emplAccess))
)
)