Forum Discussion
Solved
Filtering a table with formulas
Hello, I would like to know how I could possibly filter my table but have the table update the formulas that are in it so as not to include the filtered out section of the table. Short example: ...
- Maybe the AGGREGATE function might help, as you can ignore hidden rows with it
Maybe the AGGREGATE function might help, as you can ignore hidden rows with it
Wyn Hopkins thank you this did help. I was able to apply it to the cumulative tabs and now I'm researching how to use it with lots of IF statements.