How to Sort Data in Reports Automatically Using Excel Formulas

Excel reports are a lot easier to maintain if formulas (not macros) can sort your data automatically. The RANK function offers an easy way to do this.

exceluser.com