Ask Eijaz — the quick brown fox.
LARGE + MATCH silently repeats a row and drops a real entrant the moment two scores tie — a bug that hides in plain sight on every sales leaderboard. Here's the classic RANK+COUNTIF fix and the one-formula 365 SORTBY+TAKE alternative, plus a free workbook.
Product notes, engineering deep-dives and launch news. No spam, unsubscribe anytime.
subscribers and counting
Fresh engineering notes, design deep-dives and launch news.
Most amortization tables are a fragile ladder of copy-down formulas that shatter the moment you insert a row. Here's the classic PMT/IPMT/PPMT build, and the Excel 365 dynamic-array version that spills the whole schedule from a single cell — plus a free workbook.
Excel's NPV function quietly assumes your first cash flow lands one full period in the future — so it discounts the whole project by an extra period and hands you a number that's off by thousands. Here's the classic fix, the XNPV/XIRR way for real dates, plus a free workbook.
Standard Data Validation dropdowns have no idea what's already been chosen elsewhere — which is exactly how the same meeting room, laptop or seat ends up double-booked. Here's the classic OFFSET trick and the one-formula 365 FILTER fix, plus a free workbook.
The most-read pieces right now.
