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

Caroline Banton has 6+ years of experience as a writer of business and finance articles. She also writes biographies for Story Terrace. Vikki Velasquez is a researcher and writer who has managed, ...