RANK Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/rank/ Bestselling Excel and Power BI Courses Fri, 24 Mar 2023 06:37:40 +0000 en-US hourly 1 https://www.xelplus.com/wp-content/uploads/2022/10/cropped-site-icon-32x32.png RANK Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/rank/ 32 32 Excel RANK without Skipping Numbers (Top 3 Report with Duplicates) https://www.xelplus.com/excel-rank-without-skipping-numbers/ Sat, 16 Mar 2019 14:54:00 +0000 https://www.xelplus.com/?p=12800 Learn about Excel's Rank and Rank.EQ functions. How can you rank values without skipping numbers in between and how to create a top 3 report with duplicates.

The post Excel RANK without Skipping Numbers (Top 3 Report with Duplicates) appeared first on Xelplus - Leila Gharani.

]]> Corporate Report Makeover: Alternative for Excel Doughnut Charts https://www.xelplus.com/excel-report-makeover-alternative-for-doughnut-charts/ Thu, 19 Oct 2017 14:18:00 +0000 https://www.xelplus.com/?p=11866 Doughnut charts get a bad reputation, but they are still used in corporate reports. In this tutorial, we offer a better alternative. A bar chart with automatic sorting will tell the story in one glance. Learn, how to set it up.

The post Corporate Report Makeover: Alternative for Excel Doughnut Charts appeared first on Xelplus - Leila Gharani.

]]> Use This Instead of the Pie Chart https://www.xelplus.com/use-this-instead-of-the-pie-chart/ Wed, 24 Feb 2016 15:10:00 +0000 https://www.xelplus.com/?p=13531 A parts-to-whole chart doesn't necessarily have to be a pie chart which has gotten a rather bad rep in recent years. In this tutorial, you will learn an alternative - a bar chart sorted dynamically by rank, created with the help of RANK, and INDEX and MATCH functions.

The post Use This Instead of the Pie Chart appeared first on Xelplus - Leila Gharani.

]]>