Re: Find top 10 items in a range



would sth like (in C1):

=OFFSET($A$1,MATCH(B1,$B$1:$B$100,)-1,)

help?
.