FINDING TOP 3 CONTRIBUTORS IN YOUR DATA USING INDEX AND LARGE FORMULA

Hi Folks,

In this posting we are going to understand how to use INDEX formula along with LARGE formula to extract the top performer details from your data table.

Let us take an example to understand this concept better

In the below table I got a list of salesperson names and their respective sales. In this list of data, I want to find top 3 contributing salesperson and their sales value.

Using LARGE formula to find the 1st, 2nd and 3rd largest values in the sales value column.

Using MATCH formula to find the position of these values in sales value column

Using INDEX formula to extract the salesperson names using the positions given by MATCH formula

Here comes the beauty when the formulas are put together. Amazing isn’t it??

Happy Learning…

 

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.