When adding a filter to an Excel spreadsheet, how do I limit its scope to some rows only?
For instance, in this document:
the “Hello” column filter will contain the values 0, 2, 4, 5, 7, 9 and 27. How can I make the sum, that is the value 27, disappear from the values suggested by the filter?