To edit an array formula in Excel, click on the cell containing an array formula and then select the formula bar present at the top. You can now modify the formula as per your requirements.

A proof-of-concept for giving Excel/VBA supercharged array processing. Array languages are awesome. People should be aware of what they're missing out on. This repo offers proof-of-concept ...

The formula does work unchanged if I open the workbook in Excel, then edit the cell containing the formula. For example, if I select the cell, press F2, then enter, the formula recognises the names.

Microsoft Excel's new FILTER() function is a great tool for reporting and dashboards. We'll show you how to use it to get more done.