Forum Discussion
How to Return Text from Column 1 if Text in Other Rows Match
Hello, here is an example data set I am dealing with and what I am trying to find a formula for: In reality, I have about 85 tasks. In the second table, I want it to return for each day...
With some reduction:
=DROP(
REDUCE(
"",
DayOfWeek,
LAMBDA(acc, v,
LET(
vector, XLOOKUP(v, DayOfWeek, tally, ""),
r, SUM(N(vector = "x")),
sorted, SORTBY(tasks, vector, 1),
actual, TAKE(sorted, r),
IFNA(HSTACK(acc, actual), "")
)
)
),
,
1
)