RANDARRAY function in Excel

On 24 September 2018, Microsoft announced some new functions for Excel.  These new functions make use of changes made to Excel’s calculation engine, which enable a single formula to return (or “Spill” using the correct terminology) results into multiple cells.  RANDARRAY is one of these new functions. The RAND function calculates a single random number Read More