I am trying to find the top ten values of column B and return their respective Titles from column A.
I am using this formula:
=OFFSET($B$8,MATCH(LARGE($B$8:$B$67,1),$B$8:$B$67,0)-1,-1)
=OFFSET($B$8,MATCH(LARGE($B$8:$B$67,2),$B$8:$B$67,0)-1,-1)
It has been working for me except when the values in column B are the same, e.g. each is 31 it only returns the top Title in from column A.
How should I get this to find the nth largest value in column B and return the corresponding value in column A?
Thanks
I am using this formula:
=OFFSET($B$8,MATCH(LARGE($B$8:$B$67,1),$B$8:$B$67,0)-1,-1)
=OFFSET($B$8,MATCH(LARGE($B$8:$B$67,2),$B$8:$B$67,0)-1,-1)
It has been working for me except when the values in column B are the same, e.g. each is 31 it only returns the top Title in from column A.
How should I get this to find the nth largest value in column B and return the corresponding value in column A?
Thanks