# One of my (hopefully) last tie breaker questions

#### rob36

##### Board Regular
Here is my code:
Excel Workbook
FGHIJKLMNOP
81Top 25 Daily:Total tickets
82176518265484
83276516365477
84376428260456
85476518275354
86576518345448
87676518345448
88777104170445
89879305095640
90977301035039
911076517295237
921176302000536
931276302000536
941376302000536
951476428290133
961576428290133
971679203150230
981779202185929
991876429705728
1001977117215227
1012076428370125
1022176428370125
1032279301265923
1042379301265923
1052476516075922
1062576517045121
Purdue Actual Tool
Excel 2002
Cell Formulas
RangeFormula
I82=INDEX(Code!BK:DB,MATCH(\$M82,Code!\$DB:\$DB,0),1)
I83=INDEX(Code!BK:DB,MATCH(\$M83,Code!\$DB:\$DB,0),1)
I84=INDEX(Code!BK:DB,MATCH(\$M84,Code!\$DB:\$DB,0),1)
I85=INDEX(Code!BK:DB,MATCH(\$M85,Code!\$DB:\$DB,0),1)
I86=INDEX(Code!BK:DB,MATCH(\$M86,Code!\$DB:\$DB,0),1)
I87=INDEX(Code!BK:DB,MATCH(\$M87,Code!\$DB:\$DB,0),1)
I88=INDEX(Code!BK:DB,MATCH(\$M88,Code!\$DB:\$DB,0),1)
I89=INDEX(Code!BK:DB,MATCH(\$M89,Code!\$DB:\$DB,0),1)
I90=INDEX(Code!BK:DB,MATCH(\$M90,Code!\$DB:\$DB,0),1)
I91=INDEX(Code!BK:DB,MATCH(\$M91,Code!\$DB:\$DB,0),1)
I92=INDEX(Code!BK:DB,MATCH(\$M92,Code!\$DB:\$DB,0),1)
I93=INDEX(Code!BK:DB,MATCH(\$M93,Code!\$DB:\$DB,0),1)
I94=INDEX(Code!BK:DB,MATCH(\$M94,Code!\$DB:\$DB,0),1)
I95=INDEX(Code!BK:DB,MATCH(\$M95,Code!\$DB:\$DB,0),1)
I96=INDEX(Code!BK:DB,MATCH(\$M96,Code!\$DB:\$DB,0),1)
I97=INDEX(Code!BK:DB,MATCH(\$M97,Code!\$DB:\$DB,0),1)
I98=INDEX(Code!BK:DB,MATCH(\$M98,Code!\$DB:\$DB,0),1)
I99=INDEX(Code!BK:DB,MATCH(\$M99,Code!\$DB:\$DB,0),1)
I100=INDEX(Code!BK:DB,MATCH(\$M100,Code!\$DB:\$DB,0),1)
I101=INDEX(Code!BK:DB,MATCH(\$M101,Code!\$DB:\$DB,0),1)
I102=INDEX(Code!BK:DB,MATCH(\$M102,Code!\$DB:\$DB,0),1)
I103=INDEX(Code!BK:DB,MATCH(\$M103,Code!\$DB:\$DB,0),1)
I104=INDEX(Code!BK:DB,MATCH(\$M104,Code!\$DB:\$DB,0),1)
I105=INDEX(Code!BK:DB,MATCH(\$M105,Code!\$DB:\$DB,0),1)
I106=INDEX(Code!BK:DB,MATCH(\$M106,Code!\$DB:\$DB,0),1)
M82=LARGE(Code!\$DB:\$DB,ROW(A2))
M83=LARGE(Code!\$DB:\$DB,ROW(A3))
M84=LARGE(Code!\$DB:\$DB,ROW(A4))
M85=LARGE(Code!\$DB:\$DB,ROW(A5))
M86=LARGE(Code!\$DB:\$DB,ROW(A6))
M87=LARGE(Code!\$DB:\$DB,ROW(A7))
M88=LARGE(Code!\$DB:\$DB,ROW(A8))
M89=LARGE(Code!\$DB:\$DB,ROW(A9))
M90=LARGE(Code!\$DB:\$DB,ROW(A10))
M91=LARGE(Code!\$DB:\$DB,ROW(A11))
M92=LARGE(Code!\$DB:\$DB,ROW(A12))
M93=LARGE(Code!\$DB:\$DB,ROW(A13))
M94=LARGE(Code!\$DB:\$DB,ROW(A14))
M95=LARGE(Code!\$DB:\$DB,ROW(A15))
M96=LARGE(Code!\$DB:\$DB,ROW(A16))
M97=LARGE(Code!\$DB:\$DB,ROW(A17))
M98=LARGE(Code!\$DB:\$DB,ROW(A18))
M99=LARGE(Code!\$DB:\$DB,ROW(A19))
M100=LARGE(Code!\$DB:\$DB,ROW(A20))
M101=LARGE(Code!\$DB:\$DB,ROW(A21))
M102=LARGE(Code!\$DB:\$DB,ROW(A22))
M103=LARGE(Code!\$DB:\$DB,ROW(A23))
M104=LARGE(Code!\$DB:\$DB,ROW(A24))
M105=LARGE(Code!\$DB:\$DB,ROW(A25))
M106=LARGE(Code!\$DB:\$DB,ROW(A26))

I need a way to break the ties, so that it won't repeat the same bin, but instead it will display the other bin number as well

I think I need a code similar to:
=INDEX(Code!BK:BK,100000*MOD(LARGE(((Code!\$DB:\$DB)+(ROW(Code!\$DB:\$DB)/100000)),ROW(A2)),1),1)

however using this code simply returned a #NUM error.

Column BK lists all of the various Bin numbers,
and column DB lists the total tickets for each bin, both are currently on a pivot table, so not sure if that could be a source of error.<!-- / message -->

### Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"

Replies
10
Views
187
Replies
3
Views
359
Replies
2
Views
393
L
Replies
13
Views
790
Legacy 246103
L
Replies
0
Views
247

1,133,575
Messages
5,659,611
Members
418,514
Latest member

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back