Ranking question

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?

I see how it works, but I'm not sure it's going to help me the way I want. The way I was doing it before was this

[SALE RESULTS]
A2:A26 -- Hip #
B2:B26 -- Name
H2:H26 -- Selling Price

[SUMMARY]
A1(Hip #) --> =SUMPRODUCT(('Sheet1'!$H$2:$H$26 = C1)*('Sheet1'!$A$2:$A$26))
B1(Name) --> = INDIRECT("'Sheet1'!B" & A1 + 1)
C1(Price) --> =LARGE('Sheet1'!$H$2:$H$26, ROW())


What I get returned right now is this:

Please Login or Register  to view this content.

The problem with this is:

There were 2 horses that sold for $5500... Hip #s 4 and 12 (4 + 12 = 16)... there were also 2 that sold for $2700... Hip #s 16 and 20 (16 + 20 = 36)

The output I would like it this

Please Login or Register  to view this content.

The spreadsheet is at http://www.harnesspages.com/files/sale.xls

The 2nd sheet, 2007 PEI Trotters Summ, is the one I'm trying to produce this summary on.

Also, is there any way to open OpenDocument files in Office 2007?