Excel RANK without Skipping Numbers (Top 3 Report with Duplicates)

Excel RANK without Skipping Numbers (Top 3 Report with Duplicates) Let's look at Excel’s ranked function.  How can you rank your values in descending or ascending order and how can you rank duplicate values without skipping numbers in the sequence?es.