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 time the underlying data changed, I'd have to repeat the entire process. If I missed an update, my report would show outdated information, which isn't professional when presenting to stakeholders.

via MakeUseOf https://ift.tt/iWJvo5a