The first step to using a conditional format to highlight the first three ranking values in a data set is to use RANK.EQ() as a helper column: =RANK.EQ([@Views],[Views]) as you can see in Figure A .

Excel’s Ranking function allows you to quickly identify the highest and lowest values in a list, ... Ensure that your data is organized in a single column or row. Use the RANK Function.

Enter the “Column Column Chart” in Microsoft Excel, a clever visualization technique that combines category-level data with overall totals to tell a more complete story.