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.
MUO on MSN

This Excel function eliminated hours of manual text combining

Sifting through data just got easier with this quick and easy Excel formula.
note

Ranking Sales with Power Query Conditional Columns: How I Stopped Using 7-Level Nested IFs and Reduced Classification Errors from 15 to 0 per Month

The Friday night I realized, "I can't even read my own IF formulas anymore." Let me start with the conclusion: if you are using nested IF functions to categorize sales data into ranks like S, A, B, or ...