Aug 20 2022 08:34 PM - edited Aug 20 2022 08:43 PM
Aug 20 2022 08:34 PM - edited Aug 20 2022 08:43 PM
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.
Aug 20 2022 09:08 PM - edited Aug 20 2022 09:09 PM
In case of table column use INDEX with FILTER function. Like
=INDEX(YourFilterFunction,ROW($A1),COLUMN(A$1))