MUO on MSN

I added two dots to my Excel references and my slow workbook came back to life

Before you blame Excel, check whether your formulas are scanning a million empty rows.

'Check your ingredients': A new blueprint for using Fermi's 'Golden Rule'

Underpinning much of modern technology, from smartphones to scanning tunneling microscopes to particle colliders, is Fermi's ...
MUO on MSN

I built my own Excel function without touching VBA, and now I use it daily

If you can write an Excel formula, you can build your own function.

Excel’s AGGREGATE Fails on Arrays but Works with Grid Ranges

Learn why the Excel AGGREGATE function fails with arrays and how to fix value errors using helper columns or dynamic LAMBDA and BYROW formulas.