Ask Eijaz — the quick brown fox.
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.
Product notes, engineering deep-dives and launch news. No spam, unsubscribe anytime.
subscribers and counting
Fresh engineering notes, design deep-dives and launch news.
VLOOKUP hands the whole amount one flat rate. Graduated commission, tax brackets and bulk pricing need marginal math instead — here's the fix, the old-school way and the shiny 365 way, plus a free workbook.
The most-read pieces right now.
