Can you delete filtered rows in a table?

**Butcher1** · 02-25-2015, 12:15 PM

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.

**FDibbins** · 02-25-2015, 12:41 PM

I assume any attempt to copy and paste the filtered table and delete the original table will result in NA errors at my formula.

Try it and find out?

When I filter it doesn't effect the result of the formula.

Depending on the formula, it wont. Perhaps look at using 1 of the SUBTOTAL() functions for this?

Again, depending on the formulas, deleting rows in your table may or may not affect them

If you still have a problem, upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.

**Butcher1** · 02-25-2015, 01:01 PM

Originally Posted by FDibbins

Try it and find out?

I made it work, just not exactly how I proposed.
I applied my desired filters, copy and pasted it below the original table, deleted all but one row from the original table, cut and pasted the copy into the original table and it worked. Thanks.