Forum Discussion
Dump Error Filter Function
I'm trying to use the filter function to automate a form to take an inventory, so I need to use a formatted table, but the filter function doesn't work with a formatted table.
In case of table column use INDEX with FILTER function. Like
=INDEX(YourFilterFunction,ROW($A1),COLUMN(A$1))