Forum Discussion
Selecting or Filtering Entire Rows from a Table
I am trying to figure out how to select or filter out entire rows from a table. I have tried the FILTER function, and the MAP function paired with INDEX, MATCH, but nothing seems to work. It seems as...
=LET(
Rws,ROW(B2:B19)-1,
Rw, MATCH(A2:A19,B2:B19,0),
isnum,ISNUMBER(MATCH(Rws,Rw,0)),
FILTER(D2:F19,isnum)
)Does this return the intended result in the sample data?
OliverScheurich
It did not quite work. Here is how I tried to apply it. I am providing more of my original formula so you can get more context for my defined variables.N, SEQUENCE(Nall), M, MATCH(N, N), PIN, INDEX(PIN_PrIn, M,1), TIF_YN, INDEX(TIF_Info, M, 1), RPA, INDEX(TIF_Info, M, 2), Props, FILTER(PIN, TIF_YN = "Yes"), Rws, ROW(Props) - 1, Rw, MATCH(Props, PIN_TAG, 0), isnum, ISNUMBER(MATCH(Rws, Rw,0)), FILTER(TAGtable, isnum) )As you can see, my Props variable is the result of a filter formula, rather than a direct cell or table reference. When I tried to do Row(Props) -1, the result was a 6 row by 1 column array in which all of the cells contained a #VALUE! error. Because of that, the way I tried to apply your solution did not work, and also resulted in a #VALUE! error.
