How to show the top 10 values with corresponding usernames

[burtos]

i need to associate a username with the values of the Top 10, iam using the following formula to get the top 10 from my list =LARGE(C18:C181,1), which works great, but how if possible can i than show which username is associated with which value from 1 to 10.


The usernames are in column B and the values are in column C.


Than i have a small table showing the top10 values but need the usernames to be shown in the previous column


Column M Column N

Username Top 10 Values

 

[vasim]

Considering your sutiation you can use index match,

in M2 = index($B:$B,match($N2,$C$18:$C$181,0),1)

 

[burtos]

had to tweak it ever so slightly to get the results, but it worked a treat.


Thanks

 

[prasaddn]

Hi Burtos,


Just one question, are your values in Col C always unique or duplicates? Is it working correctly even when duplicates are present in values?


Usually, for such situations I use the data in col B and C as data for my pivot table and the place the PT in required cell of your choice and then set the PT to show only Top 10.


Regards,

Prasad DN