Inside Microsoft Excel

Easily rank your data with the RANK function

Inside Microsoft Excel

by Julie Duncan

For law students, gymnasts, and many others, rankings are vital. For instance, a business owner will want to analyze his or her products to determine what sells well and what to discontinue.

But when you need to rank your data, you may not want to resort it to do so. You may prefer, for example, to keep the data sorted by name, item number, or date. Thankfully, Excel’s RANK function allows you to[…]


Subscribe to Inside Microsoft Excel

(get full access to archives and more)