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

Some videos you may like

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.

Subscribe on YouTube

Watch MrExcel Video

Forum statistics

Threads
1,106,298
Messages
5,510,467
Members
408,791
Latest member
bwirth

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top