To work with arrays in Excel your have some options:
- Select a range of [10Rows] x [1Columns] cells.
- Press F2 to go into formula mode.
CTRL+SHIFT+ENTERto make it a array formula.
Dump & Resize
There are two macro functions in SeoTools to simplify working with arrays in Excel: