Microsoft isn't trying to confuse you—Excel's three ranking functions balance flexibility, compatibility, and tie handling.

For the fastest way to join Tom's Guide Club enter your email below. We'll send you a confirmation and sign you up to our newsletter to keep you updated on all the latest news.