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

List unique or duplicate values with Excel formulas

The Excel team recently announced new dynamic array formulas, which can create unique lists, sort and filter with a simple formula.  These new formulas are being rolled out to Office 365 subscribers over the next few months.  However, not everybody has the subscription and will upgrade when it is sensible for their business, often combining Read More

Spreadsheet Day 2018

Happy Spreadsheet Day! 17th of October is Spreadsheet Day, the day each year when we celebrate… you guessed it… spreadsheets. VisiCalc, the first spreadsheet application, shipped on 17 October 1979. Originally it was only compatible with the Apple II and cost $99. I don’t know if VisiCalc had formulas and functions. Sometimes I wonder what Read More