Forum Discussion
Return list of values in a column if another column is not empty
Hello! I am trying to create a list for "project allocations". So I have a table with all or staff members in column A and in row 1 all our projects. In the cells in between, if a staff member is as...
This builds upon Martin_Angosto 's solution to return the results as a single dynamic array
"Worksheet formula (presentation)"
= LET(
lists, REDUCE(SEQUENCE(3), project, Assignedλ),
VSTACK(project, DROP(lists,,1))
)
"LAMBDA function (calculation)"
Assignedλ
= LAMBDA(acc, proj_r,
LET(
h, XLOOKUP(proj_r, project, hours),
HSTACK(acc, EXPAND(FILTER(names, h > 0),3,,""))
)
);