1 min readfrom 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

https://preview.redd.it/2wn2273bszwg1.png?width=508&format=png&auto=webp&s=b28d94c42940d1bdcfbe225a2b7d1ecf9ff56fc6

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.

submitted by /u/EbbInevitable4008
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#rows.com