•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Can't seem to get the FILTER function to work with my VSTACK on Office 365
Our take
Are you struggling to get the FILTER function to work alongside VSTACK in Office 365? You’re not alone. This user is trying to create a dynamic master list of names that pulls from multiple sheets while eliminating blank rows. Despite the VSTACK formula functioning correctly on its own, wrapping it in FILTER leads to frustrating results—no error messages, just a display of the formula itself. If you've encountered similar issues or have solutions, your insights could help turn this challenge into a productive outcome.
The VSTACK formula works just fine before I wrap it in the filter. I'm just trying to create a master list of names that pulls dynamically from each sheet in the workbook, and eliminate the blank rows. Frustratingly, Office 365 won't give me an error - just displays the formula like this. I've tried swapping out the comma for a semicolon, doesn't fix it.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Tagged with
#rows.com#AI formula generation techniques#Excel alternatives for data analysis#formula generator#natural language processing for spreadsheets#generative AI for data analysis#Excel compatibility#Excel alternatives#financial modeling with spreadsheets#FILTER#VSTACK#Office 365#formula#master list#workbook#dynamically#blank rows#error#pulls#each sheet