Coercion of array formulas

Silver Contributor

Am I correct in my assumption/observation that array coercion of the form




is no longer needed with dynamic arrays?  Or are there still 'hidden corners' where the array formulas block?



2014 reference.

INDEX: Returning an array of values « EXCELXOR

2 Replies
just checking here, but no news on this Maestro Peter?


I probably haven't examined every hidden corner, but I have only thought of coercion a couple of times over the past 5 years and haven't used it at all.  So, unless something really unexpected crops up, it's history.

In the present case

= INDEX(array, {1,4,8})

works well, as does

= SUM(INDEX(array, {1,4,8}))

just as the OP will have established.