How-To Geek on MSN

How to create and use custom lists in Microsoft Excel

Automate repetitive data entry and fix broken sorting hierarchies using Excel's powerful, hidden Custom Lists tool.
Hosted on MSN

I use Excel's TAKE and DROP to make top-10 lists that update themselves

Creating top-10 lists in Excel can be tedious if you make them the way I used to. I'd sort the data manually, copy the highest values, and paste them into a separate section. It worked fine, but every ...