Microsoft Excel will rank whatever you want automatically. Susan Harkins will show you how. ... If there is one duplicate, meaning two values, this function will add .5 to the rank.

A straight ranking result is easy using one of Microsoft Excel’s ranking functions. Calculating a conditional rank is even easier if you let an Excel PivotTable do all the work.