Forum Discussion
filtering and reporting to individual cell for text with no VBa code necessary
I have a table that has text and when it's sorted, I need it to report the result to a single cell outside the table. Then i will be able to use in formula's elsewhere. I have accomplished the subtot...
If you have access to Lambda, this may work for you. All you have to do is provide the name of the table in the syntax: Table1[#All].
=LET(
t, Table1[#All],
records, DROP(t, 1),
header, TAKE(t, 1),
m, MAP(records, LAMBDA(e, IF(SUBTOTAL(103, e) = 1, e, ""))),
filtered, FILTER(m, TAKE(m, , 1) <> ""),
VSTACK(header, filtered)
)