One of my (hopefully) last tie breaker questions

rob36

Board Regular
Joined
Jul 12, 2010
Messages
57
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

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

Forum statistics

Threads
1,215,480
Messages
6,125,049
Members
449,206
Latest member
Healthydogs

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top