•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
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]
Want to read more?
Check out the full article on the original site
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