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...
Practically same as above, but in one spill
=LET(
marks, $B$3:$H$14,
tasks, $A$3:$A$14,
header, $B$2:$H$2,
seq, SEQUENCE( COLUMNS( header ) ),
filtered, BYCOL(marks, LAMBDA(v, LAMBDA( FILTER(tasks, v <> "" ) ) ) ),
combined, IFNA( DROP( REDUCE("", seq, LAMBDA(a,v, HSTACK(a, INDEX(filtered,1,v)() ))),,1), "" ),
result, VSTACK( header, combined),
result
)