FILTER Function only returning top 10 results?

Hi all,

I have a FILTER function that I want to use on a spreadsheet with 3000 rows; I don't want to use the filter setting within the actual spreadsheet but instead automatically draw out the data (copying the row where a cell matches) to a separate sheet that can be stored in a different area of sharepoint with different permissions.

Is there a limit to how much this function will return, or a formatting trick that I am missing?

I have checked the formatting in the original spreadsheet, and it all seems to be working fine there - but for some reason it's only picking up the top 10 when copying things across.

Thanks

I've changed the formula to point to a cell as opposed to text, and now it works in reverse - giving me all the other results, except for the first 10! There's clearly something in the way it has been set up that I need to find out (although the cells all appear using the filter in the data source spreadsheet).

Curious!