I'm making a spreadsheet to record the results of a horse sale, and I'm trying to make a summary sheet to list various statistics such as the 10 top sellers, 10 worst sellers, etc.

Now, I know I can get the 10 top prices easily by using Large(<Range>, 1...10) in my cells but I can't figure out a way to properly determine the hip # and name. Everything works fine when there's only 1 entry at price n, but when there are multiple I run into problems.

EX:

Horse 1 sold for $5500
Horse 2 sold for $8500
Horse 3 sold for $5500
Horse 4 sold for $6000

So, my summary should show
Horse 2 $8500
Horse 4 $6000
Horse 1 $5500
Horse 3 $5500


Is there any way to do this?