MacMost Q&A Forum • View All Forum QuestionsAsk a Question

Excel FILTER Function Alternates In Numbers?

In MS Excel there is a FILTER function.
Is there any alternative in Apple Numbers?

I have a table containing movies with their categories.

Now I want to create a second table that displays movies of a specified category.

In MS Excel this can be done using FILTER function but there are no FILTER function in Number.
Is there any way to do the same ?
—–
Gajendra Jangid

Comments: One Response to “Excel FILTER Function Alternates In Numbers?”

    1 month ago

    The primary way to do this would be to simply use filters. See https://macmost.com/single-tables-filters-and-categories-in-mac-numbers.html

    The main difference between that and what you are describing is that it doesn't create a second table. You just filter the first table. It is easy to turn filters on and off and change them, so hopefully this is all you need.

    Otherwise, you can use other functions if you really need to generate a new table. For instance, in this video I show an example of creating invoices by pulling data from another table.
    https://macmost.com/creating-a-billing-and-invoicing-system-in-numbers.html

    If you are clever, another option is to use a Pivot Table. But it is a bit convoluted and messy.

Leave a New Comment Related to "Excel FILTER Function Alternates In Numbers?"

:
:
:
0/500 (500 character limit -- please state your comment succinctly and do not try to get around this limit by posting two comments)