# Cloud Stack Ninja

I have a sheet with several columns, containing a Name in the first cell, and then different values in the other cells.

Example:-

``````John Smith    65  40  30  30  50
Paul White    80  20  50  90  10
Karen Gill    75  34  16  19  88
Norman Black  85  10  40  43  25
Peter Smith   44  40  33  12  50
(etc........)
``````

Now I am trying to order these by the top 5 in every cell, and display them with Name and Value. I am doing something like this at the moment:-

``````=INDEX(DefC!A\$4:A\$150,MATCH(LARGE(DefC!Y\$4:Y\$150,1),DefC!Y\$4:Y\$150,0))
=INDEX(DefC!A\$4:A\$150,MATCH(LARGE(DefC!Y\$4:Y\$150,2),DefC!Y\$4:Y\$150,0))
=INDEX(DefC!A\$4:A\$150,MATCH(LARGE(DefC!Y\$4:Y\$150,3),DefC!Y\$4:Y\$150,0))
=INDEX(DefC!A\$4:A\$150,MATCH(LARGE(DefC!Y\$4:Y\$150,4),DefC!Y\$4:Y\$150,0))
=INDEX(DefC!A\$4:A\$150,MATCH(LARGE(DefC!Y\$4:Y\$150,5),DefC!Y\$4:Y\$150,0))
``````

This works perfectly, however, if I have the same value, I am getting the same name, instead of different names. If I take my example, I have 40 and 50 in row 1 and row 5. So at the moment for the second row of values I would get :-

``````John Smith    40
John Smith    40
Karen Gill    34
Paul White    20
Norman Black  10
``````

``````John Smith    40
Peter Smith    40
Karen Gill    34
Paul White    20
Norman Black  10
``````

Can I do it any other way so that I can get the "second" name if the value is the same, instead of the same name?