Forum Discussion

Deleted's avatar
Deleted
Aug 20, 2022

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.

 

 

1 Reply

  • Harun24HR's avatar
    Harun24HR
    Silver Contributor

    In case of table column use INDEX with FILTER function. Like

     =INDEX(YourFilterFunction,ROW($A1),COLUMN(A$1))