Excel FILTER Function Alternates In Numbers?

Question

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 ? &#8212;&#8211; Gajendra Jangid

Accepted Answer

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&#8217;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. Creating a Billing and Invoicing System In Numbers  If you are clever, another option is to use a Pivot Table. But it is a bit convoluted and messy.

Search MacMost By Tag or Keywords

Tag Search: “excel” (1 results)

Welcome to MacMost

Free Weekly Newsletter

MacMost Online Courses

Keyboard Shortcuts PDF

Connect with MacMost

MacMost Sections

Popular Tutorials

Information