How-To Geek on MSN

Why I'm swapping my PivotTables for the PIVOTBY function in Excel

PivotTables are static relics; PIVOTBY is the responsive, resilient, and fully auditable future of the modern Excel ...
Hosted on MSN

Excel's UNIQUE function can't skip columns—unless you use this trick

Excel's UNIQUE function is a game-changer for cleaning data, but it has a frustrating limitation: it only works with adjacent columns. But by nesting additional functions inside it, you can create a ...