PivotTables are great for quick analysis, but they break down when you rely on them for serious reporting workflows.
How-To Geek on MSN
Rank vs. Rank.eq vs. Rank.avg: Why Microsoft created three Excel functions for one job
Microsoft isn't trying to confuse you—Excel's three ranking functions balance flexibility, compatibility, and tie handling.
Some results have been hidden because they may be inaccessible to you
Show inaccessible results