=Dump({object vector}, [transpose=FALSE]) : object

Macro function that takes an array output of another function and Dumps it on the spreadsheet.

Using this function together with an array function such as XPathOnUrl is pretty powerful (and will make it work like Google Docs’s ImportXML).

Note: Dump() adds a comment in the formula cell to be able to remember what cells to clean-up when input changes in size.

See: Working with arrays in Excel, Resize.

Get help with this function in the community →