Forum Discussion
Solved
OFFSET on results of FILTER
I assume I'm making a basic error or overlooking something silly. _test is a 5 column table with a column Bool. I want the first two columns only, for those rows where Bool is "Yes". I have a...
OFFSET() requires range as first parameter, not an array. Instead you may use something like
=LET( matches,FILTER(_test,_test[Bool]="Yes","None"), shows, OFFSET(matches,0,0,,2), one, FILTER(matches, {1,1,0,0,0} ), two, INDEX( matches, SEQUENCE(ROWS(matches)), {1,2}), two )
OFFSET() requires range as first parameter, not an array. Instead you may use something like
=LET(
matches,FILTER(_test,_test[Bool]="Yes","None"),
shows, OFFSET(matches,0,0,,2),
one, FILTER(matches, {1,1,0,0,0} ),
two, INDEX( matches, SEQUENCE(ROWS(matches)), {1,2}),
two
)