How to save filters in Numbers to resue them?

Question

Level 1

38 points

How to save filters in Numbers to resue them?

Apple Numbers has a built in filters. Here are a set of filters that I use all the time:

I apply these filters all the time (and then sort the column titled "COMPETITIVE SCORE" by ascending to descending) .

Is there anyway I can save these filters (and the sorted column), so I can call them up with one click instead of having to select them all the time?

I tried looking at Apple Script but it doesn't seem possible to control the filters via Apple Script.

Thanks!

Posted on Jun 4, 2020 2:56 AM

Reply

Answer 1

★ Helpful

SGIII

Level 7

34,665 points

Jun 4, 2020 7:06 AM in response to big_smile

If you've set up the filters as in your screenshot, then you can turn them off and on with the "switch" at the upper right. You don't have to set them up again each time.

SG

Reply

Answer 2

Best answer

Yellowbox

Level 6

19,992 points

Jun 4, 2020 7:22 AM in response to big_smile

Hi big_smile,

It is often tricky to filter on values that are "not".

Without some idea of your overall aim, I made up this table.

Table 1 has a Header Row.

Formula in B2 =IFERROR(FIND(B$1,$A2),"0")

Fill right and fill down.

IFERROR inserts 0 if the value in the relevant Header Row is not found.

Formula in E2 =SUM(B2:D2)

Fill down.

Now for the filter:

Press the return key to confirm.

The filter shows only those rows that do not contain < or - or N/A in column A.

Happy Numbering!

Ian.

Reply

Answer 3

big_smile Author

Level 1

38 points

Jun 4, 2020 2:31 PM in response to SGIII

Just to clarify, I apply these filters to multiple documents (probably hundreds, because new ones are made daily)

(I should have made that clearer!).

Reply

Answer 4

big_smile Author

Level 1

38 points

Jun 4, 2020 2:31 PM in response to Yellowbox

@Ian, thanks I will give this a try. I apply these filters to multiple documents (probably hundreds, because new ones are made daily), so I will give your formulas a try and see if it makes things quicker. Thanks for your help (and I should have made it cleaer that I apply it to multiple documents!)

Reply

Answer 5

★ Helpful

Barry

Level 9

59,804 points

Jun 4, 2020 7:16 PM in response to big_smile

Do these 'hundreds of documents' have the same structure?

If so, use Ian's example as a model for the 'filterable' version of that document structure, leaving the number of columns needed to contain the 'made daily' document's data columns. Save the document (with no data in thee columns) as a template.

Then for each 'daily document:

Create a new document from the template.

Open the 'daily document' and select all data cells, then Copy.

Switch to the new document created from the template.

Select the top left cell of the cells ready to accept data. Paste.

Apply the filters as needed.

Regards,

Barry

Reply

How to save filters in Numbers to resue them?

Similar questions