Struggling with Formula of data between tabs

Question

We've got a data sheet(Tab) with data in it.

Then we have other sheets(Tabs) called stock ordered/stock sold/ stock available, that we need to pull the data to, but it needs to sort the data from ordered/sold/instock from the Data sheet(tab)?

This is the formula:

=_xlfn._xlws.FILTER(Data!A3:I2979;Data!B3:B2979=StockAvailb!E2)

But it keeps giving me #NAME?

riny_van_eekelen · Answer

JDCollins&nbsp;Your Excel version doesn't support the FILTER function. Then you get the NAME error you describe.https://support.microsoft.com/en-us/office/filter-function-f4f7cb66-82eb-4767-8f7c-4877ad80c759&nbsp;

Forum Discussion

Struggling with Formula of data between tabs

1 Reply