Forum Discussion
FILTER function across multiple sheets, display in separate sheet
I have 3 spreadsheets labeled 'lesson 1', 'lesson 2', and 'lesson 3'. I made a 4th spreadsheet labeled 'planner sheet'. In the first cell in the 'planner sheet' I put the formula: ={FILTER('les...
Attach a Excel file to your post so that we can see your sample data correct your formula. You need VSTACK() function if you have access to beta channel or current preview channel.