Excel Dynamic Charts : Top 5 Values & Others

[@darylfunk2226]

😀 Promo*SM

[@luigibru8677]

What if there are 2 "Annual sales" with the same amounts and we want to rank them as below in alphabetical order? Coffee table - $2,000,000 - Rank 1 Wardrobe - $2,000,000 - Rank 2 Thanks!

[@TEKNISHA]

If there are 2 numbers with same value they will be ranked same. There is a 2 step process to get different ranks for same amounts, however to put them alphabetically will involve a little more complexity..