MUO on MSN

SUM is good, SUBTOTAL is great, but this Excel function beats them both

Your reports should remain stable even when your data gets messy. AGGREGATE is the only function that survives both filtered ...
MUO on MSN

I’ve been overcomplicating Excel lookups with VLOOKUP — this obscure function changed that

If your VLOOKUP formula needs a helper column, try DGET instead.
JournalofAccountancy

Say bye to PivotTables with Excel’s new PIVOTBY function

Q. Traditional PivotTables have always intimidated me. I see there is a new Excel function called PIVOTBY. What is the difference between it and the traditional PivotTable? With the PIVOTBY function, ...
JournalofAccountancy

Using Excel’s TEXTBEFORE AND TEXTAFTER functions to easily tame messy data

Q. How do the TEXTBEFORE and TEXTAFTER functions in Excel work? A. Excel’s TEXTBEFORE and TEXTAFTER functions allow users to quickly split up text in ways that used to require combinations of ...