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.