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.
note

Automating Unit Price Retrieval in Excel Price Lists with XLOOKUP Cross-Reference: From INDEX×MATCH to Zero Transcription Errors per Month

8 hours a month spent just on "picking up unit prices." That can be eliminated with a single formula. Last October, I watched an accountant at a shipping company prepare invoices. On the desk was a ...
note

Write if-statement conditions in the 'affirmative'—how to fix hard-to-read conditional expressions

// 読みにくい:否定形が先 if (!isLoggedIn) { redirectToLogin(); } else { showDashboard(); } // 読みやすい:肯定形が先 if (isLoggedIn ...
Yonkers Times

Best Confluence Alternatives for Modern Team Documentation in 2026

Atlassian Confluence has been the default documentation platform for engineering teams since 2004. It offers organized spaces ...

Excel’s Hidden N Function Lets You Add Comments Inside Formulas

Embed Excel formula comments directly into your math using the N and REPT functions to keep your spreadsheet documentation ...
GitHub

philschmid/ai-agent-benchmark-compendium

Compendium of over 50 benchmarks for evaluating AI agents, categorized into Function Calling & Tool Use, General Assistant & Reasoning, Coding & Software Engineering, and Computer Interaction. - ...