INDEX MATCH Error

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

Hi

I tried what you said and it worked to an extent, but it is getting confused by duplicate numbers.

I have included the file if this helps any?

Sorry RE the picture, I am not very experienced.

R x

Hi,

Please see the attached file, I have added a helper column for ranking the range and then top 10.

In Column M: RANK(L10,$L$10:$L$26,0)+COUNTIF($L$10:L10,L10)-1
Column S: =INDEX($B$8:$M$26,MATCH(ROW(A1),$M$8:$M$26,0),2)

Thank you! Much appreciated.
Worked perfectly!

You are welcome

If that takes care of your question, please mark this thread as Solved by selecting Thread Tools --> Mark thread as solved.

Also, I would like to inform you that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful.

Hi you helped me yesterday with this issue. This has worked perfectly, but I am not trying to do the same again but with a different column.

What would I need to change to create the same process but this time just using numbers in column D?

Rx

Hi

This did work to an extent but only did the top three names the rest of the top ten was just #?N/A

Must be something simple im sure but not seeing it.

Rx

Column "D" does not contain any data in the file which you had uploaded. Are you trying to SORT by "DHU Score" which is column E?

I have included a sample file to explain the problem.

I am trying to create a table to each of the columns listed E - J.

Obviously from the offices in Column C.

Thanks again for any help.

Rebecca x

Hi,

Please see the updated file attached.

Hi

Really sorry my fault as I was not very clear, its the names of the offices I want to prioritise. So the office with the highest number would be at the top working down.

As in example (in yellow) it works but only for the first 2 occurrence's.

I very much appreciate all your help in this matter.

Rebeccaxx

Hi

Really sorry my fault as I was not very clear, its the names of the offices I want to prioritise. So the office with the highest number would be at the top working down.

As in example (in yellow) it works but only for the first 2 occurrence's.

I very much appreciate all your help in this matter.

Rebeccaxx