I have some formulas that reference a table. When I filter it doesn't effect the result of the formula. Is there anyway to delete those filtered rows? I assume any attempt to copy and paste the filtered table and delete the original table will result in NA errors at my formula.