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
Bookmarks