Hi Guys!
I have a large table of data from which I want to extract the top 10 positions of the field "AbsJuanma"
Using: =LARGE(Table17[AbsJuanma],1) I can make a top ten of the largest positions.
However Now I want to identify the row in which this number is and extract more information from other columns of the same row. I use:
=MATCH(Z84,Table17[AbsJuanma],0) (Z84) is the cell with the large
This cell returns the row of the Largest number.
HOWEVER, whentwo numbers in the top10 are the same, the MATCH returns the first of the two in its search, so if AbsJuanma contains 10000 twice, it will give the adress of the first 10000 location two times. How can I solve this?
Is there something like, if MATCH returns a value equal to the above cell, keep looking?
Thanks!
Bookmarks