Rank multiple criteria, not repeating

Dear All,

​I have a rank formula that allows me to extract top 10 data, but if the data is less than 10, the rank repeats its self.

=INDEX(C6:C1048576,MATCH(LARGE(D6:D1048576,ROW(A1:A10)),D6:D1048576,0),1)

I have been trying to upload the excel sheet, I always get an error. hope the picture will help

i have attached the excel sheet for reference, hope someone can help improve my current formula. thank you.

Francis






francis