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:
10 Stormy Song $8,500
11 Rustico Joey $6,200
16 Up With The Birds $5,500
16 Up With The Birds $5,500
14 Dunmore Bling $5,000
36 0 $2,700
36 0 $2,700
19 Nabbed $2,600
21 Dusty Lane Ashlyn $2,500
17 Accolade Seelster $2,100
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
10 Stormy Song $8,500
11 Rustico Joey $6,200
4 Meadowbank $5,500
12 Dunmore Chip $5,500
14 Dunmore Bling $5,000
16 Up With The Birds $2,700
20 Debs Nabby $2,700
19 Nabbed $2,600
21 Dusty Lane Ashlyn $2,500
17 Accolade Seelster $2,100
Bookmarks