Forum Discussion
CoolYourJets
Oct 18, 2024Copper Contributor
Subtotal, but it returns text?
Hello everyone! I was wondering if you knew how to help me find an appropriate excel formula. Is there a formula like SUBTOTAL, but that returns the visible text value from a filtered table? Here...
Patrick2788
Oct 18, 2024Silver Contributor
This function will return the visible text in a table. All you have to do is provide the table or column from a table. If you want to see visible entries in 1 column of the table - provide 1 column, entire table - provide the entire table, etc.
VisibleRows = LAMBDA(table,
LET(
arr, TAKE(table, , 1),
visible, MAP(arr, LAMBDA(v, SUBTOTAL(3, v))),
result, FILTER(table, visible),
result
)
)
The attached workbook contains the function.