Forum Discussion
JDCollins
Aug 24, 2022Copper Contributor
Struggling with Formula of data between tabs
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 or...
Riny_van_Eekelen
Aug 24, 2022Platinum Contributor
JDCollins 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