Auditing Dynamic Array Events

[Smarti1]

I have started to implement dynamic arrays in worksheets but users still want to be able to look at the results in single cells to verify calculations.
The dynamic arrays save space and increase speed but users find it difficult to verify results of individual cells.
For example, if a dynamic arrays spills results down column C, is there any way to "edit" the result in cell c10?
Similar to hitting F9 on an individual cell formula to see the component parts of the formula or just clicking in the cell to see the referenced cells.

 

[awoohaw]

The F9 to see portions of the calculation in a formula still works in dynamic array formulas. Depending on how big the formula is makes the calculated values easier or more difficult to see.

But, the users can see the cells and ranges selected in formulas as they are given colored borders when in edit mode.

Short of those two, it requires the same faith that a formula was copied correctly or a date was not entered as text in worksheets prior to your introduction of them to your team.

One only thing you could do, is provide a worksheets with an array formula built column by column with each additional part of the formula added with each column.
You can also show them the formula auditing tool on the formula ribbon.