Large and index formula

[Dustt24]

Ive been trying to follow this youtube video (

) which uses large to create a top 10 table and then index to copy over ajoining names to these values. however if i have values that are the same then the name is copies rather than displaying the correct name for the value.
for example displays
A, 1
B, 2
B, 2
D, 3
rather than
A,1
B,2
C, 2
D, 3
. I hope this makes sense to understand I really need a fix for this

 

[RoryA]

Welcome to the forum.

There are various options, depending on which version of Excel you need them to work with. A pivot table is a simple one, but needs refreshing if you change your data. A FILTER function would work, if your version supports it (2021/365), or a combination of TAKE and SORT if you have those.