I am trying to create a formula to create a top ten display. I want this to be calculated automatically.

I have the office names in column C and the score in column K. Would like the result to go into column S & T.

I think I can use the Index / Match function but I think this falls down when I get duplicate numbers in column K.

I can get the top ten numbers displayed easily enough by using the LARGE function, but want the corresponding office name from column C to be displayed in order next to the number.

A long after noon and I am nowhere any ideas anyone.

I hope this makes sense!1.JPG

Thank you in advance for any help that can be given

Rebecca x