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??