Posts by FlameRetired

Important Notice


Please note that on 14th December 2023 users will experience an expected outage whilst we make upgrades to our network. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.

    This alternative might simpler to follow on the Phase #s extraction part.

    Code
    =IFERROR(SUMPRODUCT(INDEX(Data!$A$2:$BG$100,,MATCH(Summary!$A3,Data!$A$1:$BG$1,0))*
    (INDEX(Data!$A$2:$BG$100,,MATCH($B$2,Data!$A$1:$BG$1,0))=$B3)*(INDEX(Data!$A$2:$BG$100,,MATCH("Type",Data!$A$1:$BG$1,0))=C$2)*
    (INDEX(Data!$A$2:$BG$100,,MATCH("Phases",Data!$A$1:$BG$1,0))=[COLOR=#FF0000][B]--TRIM(RIGHT(SUBSTITUTE(LOOKUP("zzzzz",$C$1:C$1)," ",REPT(" ",99)),99))[/B][/COLOR])),0)

    Before starting I noticed there is a "Key" designation in 'Summary' B1. I saw no indications in examples that you wish to include those (from column 'Data' BG). If you do you will need to include additional criteria. Hopefully the enclosed can serve as a guide on how to do that.


    The formula filled down and across

    Code
    =IFERROR(SUMPRODUCT(INDEX(Data!$A$2:$BG$100,,MATCH(Summary!$A3,Data!$A$1:$BG$1,0))*
    (INDEX(Data!$A$2:$BG$100,,MATCH($B$2,Data!$A$1:$BG$1,0))=$B3)*(INDEX(Data!$A$2:$BG$100,,MATCH("Type",Data!$A$1:$BG$1,0))=C$2)*
    (INDEX(Data!$A$2:$BG$100,,MATCH("Phases",Data!$A$1:$BG$1,0))=LOOKUP(1E+306,--RIGHT(LOOKUP("zzzz",$C$1:C$1),ROW($1:$10))))),0)


    There are merged cells in 'Summary,' and the Phases numbers in 'Data' suggest there could be multiple digit phase #s. If you are not aware of it merged cells cause havoc for formulas. In consideration of both find this portion of the formula that extracts Phase #s. It is reliable but a bit involved. If you would like help analyzing it please let us know.

    Code
    LOOKUP(1E+306,--RIGHT(LOOKUP("zzzz",$C$1:C$1),ROW($1:$10)))

    .

    Without a representative data set that reflects the dilemma I can't say. However it sounds like it would be a simple matter of changing the relative column ranges in the formula. If the header labels are exactly the same I wouldn't think that would be a problem.


    With the exception of the column of 1's all the formulas are driven by the formula component:


    MATCH(1,INDEX(--(ROWS(E$3:E3)<=SUBTOTAL(9,OFFSET(INDEX(Units,1),,,ROW(Units)-MIN(ROW(Units))+1))),0),0)


    It always returns each item in the 'Fruit', 'Units' and 'Total Cost' n number of Units times.


    However:

    Quote

    ... the data set is large


    You hadn't mentioned that before. That would be the only potential problem as I see from the description. As OFFSET is a volatile function too many of them can slow a workbook down. Up to about 1000 cells this is usually not a problem.


    In numbers ... rows and columns ... how large is the anticipated output range?

    Sure if a formula works that just as good, it does not have to be VBA


    Find the following dynamic named ranges in Name Manager:

    [Table="class: grid"]

    [tr][td]

    Fruit

    [/td][td]

    =Sheet1!$A$3:INDEX(Sheet1!$A:$A,MATCH("zzzzzz",Sheet1!$A:$A,1))

    [/td][/tr]


    [tr][td]

    Total_Cost

    [/td][td]

    =Sheet1!$C$3:INDEX(Sheet1!$C:$C,MATCH(1E+306,Sheet1!$C:$C,1))

    [/td][/tr]


    [tr][td]

    Units

    [/td][td]

    =Sheet1!$B$3:INDEX(Sheet1!$B:$B,MATCH(1E+306,Sheet1!$B:$B,1))

    [/td][/tr]


    [/table]


    Then in E3 and filled down

    Code
    =IF(ROWS(E$3:E3)>SUM(Units),"",INDEX(Fruit,MATCH(1,INDEX(--(ROWS($1:1)<=SUBTOTAL(9,OFFSET(INDEX(Units,1),,,ROW(Units)-MIN(ROW(Units))+1))),0),0)))


    In F3 and filled down

    Code
    =IF(ROWS(E$3:E3)>SUM(Units),"",1)


    And in G3 and filled down

    Code
    =IF(ROWS(E$3:E3)>SUM(Units),"",ROUND(INDEX(Total_Cost,MATCH(1,INDEX(--(ROWS($1:1)<=
    SUBTOTAL(9,OFFSET(INDEX(Units,1),,,ROW(Units)-MIN(ROW(Units))+1))),0),0))/
    INDEX(Units,MATCH(1,INDEX(--(ROWS($1:1)<=SUBTOTAL(9,OFFSET(INDEX(Units,1),,,ROW(Units)-MIN(ROW(Units))+1))),0),0)),2))

    [SIZE=14px]I think F5 (or Ctrl+G) is the most useful [/SIZE][SIZE=14px]work around[/SIZE][SIZE=14px] to go to the Name box directly in Excel [/SIZE][SIZE=14px]till[/SIZE][SIZE=14px] Ver 2016.[/SIZE]


    Did something change in Ver 2016? If so please enlighten me. Thanks.

    Re: Lookup Values in any column


    Edit Never mind. This won't work. There are duplicate numbers in Post #1, and if one of those numbers is entered in A1 it errors. :(


    This is one way to do it.


    This formula in B1

    Code
    =INDEX($A$2:$F$11,MATCH(1,MMULT(--(A1=$A$2:$F$11),{1;1;1;1;1;1}),0),MATCH(1,MMULT({1,1,1,1,1,1,1,1,1,1},--(A1=$A$2:$F$11)),0)+1)


    [TABLE="class: grid"]

    [tr]


    [td]

    Row\Col

    [/td]


    [td]


    A


    [/td]


    [td]


    B


    [/td]


    [td]


    C


    [/td]


    [td]


    D


    [/td]


    [td]


    E


    [/td]


    [td]


    F


    [/td]


    [/tr]


    [tr]


    [td]


    1


    [/td]


    [td]

    EL3

    [/td]


    [td]


    220


    [/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [/tr]


    [tr]


    [td]


    2


    [/td]


    [td]

    EL1

    [/td]


    [td]


    73


    [/td]


    [td]

    PL1

    [/td]


    [td]


    55


    [/td]


    [td]

    HVAC1

    [/td]


    [td]


    73


    [/td]


    [/tr]


    [tr]


    [td]


    3


    [/td]


    [td]

    EL2

    [/td]


    [td]


    146


    [/td]


    [td]

    PL2

    [/td]


    [td]


    110


    [/td]


    [td]

    HVAC2

    [/td]


    [td]


    146


    [/td]


    [/tr]


    [tr]


    [td]


    4


    [/td]


    [td]

    EL3

    [/td]


    [td]


    220


    [/td]


    [td]

    PL3

    [/td]


    [td]


    165


    [/td]


    [td]

    HVAC3

    [/td]


    [td]


    220


    [/td]


    [/tr]


    [tr]


    [td]


    5


    [/td]


    [td]

    EL4

    [/td]


    [td]


    293


    [/td]


    [td]

    PL4

    [/td]


    [td]


    220


    [/td]


    [td]

    HVAC4

    [/td]


    [td]


    293


    [/td]


    [/tr]


    [tr]


    [td]


    6


    [/td]


    [td]

    EL5

    [/td]


    [td]


    366


    [/td]


    [td]

    PL5

    [/td]


    [td]


    275


    [/td]


    [td]

    HVAC5

    [/td]


    [td]


    366


    [/td]


    [/tr]


    [tr]


    [td]


    7


    [/td]


    [td]

    EL6

    [/td]


    [td]


    439


    [/td]


    [td]

    PL6

    [/td]


    [td]


    330


    [/td]


    [td]

    HVAC6

    [/td]


    [td]


    439


    [/td]


    [/tr]


    [tr]


    [td]


    8


    [/td]


    [td]

    EL7

    [/td]


    [td]


    512


    [/td]


    [td]

    PL7

    [/td]


    [td]


    385


    [/td]


    [td]

    HVAC7

    [/td]


    [td]


    512


    [/td]


    [/tr]


    [tr]


    [td]


    9


    [/td]


    [td]

    EL8

    [/td]


    [td]


    585


    [/td]


    [td]

    PL8

    [/td]


    [td]


    440


    [/td]


    [td]

    HVAC8

    [/td]


    [td]


    585


    [/td]


    [/tr]


    [tr]


    [td]


    10


    [/td]


    [td]

    EL9

    [/td]


    [td]


    659


    [/td]


    [td]

    PL9

    [/td]


    [td]


    495


    [/td]


    [td]

    HVAC9

    [/td]


    [td]


    659


    [/td]


    [/tr]


    [tr]


    [td]


    11


    [/td]


    [td]

    EL10

    [/td]


    [td]


    732


    [/td]


    [td]

    PL10

    [/td]


    [td]


    550


    [/td]


    [td]

    HVAC10

    [/td]


    [td]


    732


    [/td]


    [/tr]


    [/TABLE]

    Re: Subtracting a number of months to a date


    Have you tried EDATE?


    Syntax is

    Code
    =EDATE(start_date, months)


    I don't know how you would reference values in TextBox6 unless it is the name of a cell, but you can add (or subtract) number of months to / from the start date.


    I couldn't tell from the upload.


    Did this help?

    Re: Formatting dates


    Quote from S O;771743

    I think the logic for the date is a constant "1" followed by the date formatted as YYMMDD:


    ="1"&TEXT(A1,"YYMMDD") obviously a bit more complex in the actual solution, just showing as an example


    other than that, brilliant formula :)


    Good catch. I lost the "6" in the "brush". Thanks for the backup. :)

    Re: Formatting dates



    Try this formula.

    Code
    =11&TEXT(MID(A1,FIND("-",A1)-4,99),"mmdd")&" - Pdate "&TEXT(INT(MOD(--MID(A1,FIND("-",A1)-4,99),1)*24),"0")&" - PHour "&TEXT(INT(MOD(MOD(--MID(A1,FIND("-",A1)-4,99),1)*24,1)*60),"0")&" - Pmin"



    [TABLE="class: grid"]

    [tr]


    [TD="bgcolor: #DCE6F1"][/TD]
    [TD="bgcolor: #DCE6F1"]

    A


    [/TD]
    [TD="bgcolor: #DCE6F1"]

    B


    [/TD]

    [/tr]


    [tr]


    [TD="bgcolor: #DCE6F1"]

    1


    [/TD]

    [td]


    ProcessDate as 2016-05-18 19:27:40


    [/td]


    [td]


    110518 - Pdate 19 - PHour 27 - Pmin


    [/td]


    [/tr]


    [/TABLE]

    Re: Align several columns into 1 columns


    Another way with formulas.


    A helper column in B with this array-entered formula in B5 and filled down until you get blanks.

    Code
    =IF(ROWS($5:5)>COUNTA($A$1:$C$3),"",SMALL(IF($A$1:$C$3<>"",COLUMN($A$1:$C$3)),ROWS($5:5)))

    If you aren’t familiar with array-entered formulas array enter means the formula must be committed from edit mode by simultaneously pressing and holding down Ctrl and Shift while hitting Enter. (CSE for short.)
    Then this regular formula in A5 filled down until you get blanks.

    Code
    =IF(B5="","",INDEX($A$1:$C$3,COUNTIF($B$5:B5,B5),B5))



    [Table="class: grid"]

    [tr]

    [td="bgcolor: #DCE6F1"][/td][td="bgcolor: #DCE6F1"]

    A

    [/td][td="bgcolor: #DCE6F1"]

    B

    [/td][td="bgcolor: #DCE6F1"]

    C

    [/td]

    [/tr]


    [tr]

    [td="bgcolor: #DCE6F1"]

    1

    [/td]

    [td]

    a

    [/td][td]

    D

    [/td][td]

    g

    [/td][/tr]


    [tr]

    [td="bgcolor: #DCE6F1"]

    2

    [/td]

    [td]

    b

    [/td][td]

    E

    [/td][td]

    h

    [/td][/tr]


    [tr]

    [td="bgcolor: #DCE6F1"]

    3

    [/td]

    [td]

    c

    [/td][td]

    F

    [/td][td][/td][/tr]


    [tr]

    [td="bgcolor: #DCE6F1"]

    4

    [/td]

    [td][/td][td][/td][td][/td][/tr]


    [tr]

    [td="bgcolor: #DCE6F1"]

    5

    [/td]

    [td]

    a

    [/td][td]

    1

    [/td][td][/td][/tr]


    [tr]

    [td="bgcolor: #DCE6F1"]

    6

    [/td]

    [td]

    b

    [/td][td]

    1

    [/td][td][/td][/tr]


    [tr]

    [td="bgcolor: #DCE6F1"]

    7

    [/td]

    [td]

    c

    [/td][td]

    1

    [/td][td][/td][/tr]


    [tr]

    [td="bgcolor: #DCE6F1"]

    8

    [/td]

    [td]

    D

    [/td][td]

    2

    [/td][td][/td][/tr]


    [tr]

    [td="bgcolor: #DCE6F1"]

    9

    [/td]

    [td]

    E

    [/td][td]

    2

    [/td][td][/td][/tr]


    [tr]

    [td="bgcolor: #DCE6F1"]

    10

    [/td]

    [td]

    F

    [/td][td]

    2

    [/td][td][/td][/tr]


    [tr]

    [td="bgcolor: #DCE6F1"]

    11

    [/td]

    [td]

    g

    [/td][td]

    3

    [/td][td][/td][/tr]


    [tr]

    [td="bgcolor: #DCE6F1"]

    12

    [/td]

    [td]

    h

    [/td][td]

    3

    [/td][td][/td][/tr]


    [tr]

    [td="bgcolor: #DCE6F1"]

    13

    [/td]

    [td][/td][td][/td][td][/td][/tr]


    [/table]

    Re: Count the values by ignoring cells which contain NA


    Hi ravs_1006, and Welcome.


    It would be helpful if you could upload a sample Excel workbook of what you describe. Live data often clarifies at a glance.


    How do I attach a file to a post?

    To attach a file to your post, you need to be using the main 'New Post' or 'New Thread' page and not 'Quick Reply'. To use the main 'New Post' page, click the 'Post Reply' button in the relevant thread.

    On this page, below the message box, you will find a button labelled 'Manage Attachments'. Clicking this button will open a new window for uploading attachments. You can upload an attachment either


    from your computer or from another URL by using the appropriate box on this page. Alternatively you can click the Attachment Icon to open this page.

    To upload a file from your computer, click the 'Browse' button and locate the file. To upload a file from another URL, enter the full URL for the file in the second box on this page. Once you have


    completed one of the boxes, click 'Upload'.

    Once the upload is completed the file name will appear below the input boxes in this window. You can then close the window to return to the new post screen.

    Re: Counting numbers that appear in succession over different columns


    Another way with data in A1:E13.


    With this array-entered formula in C16 as in the below and filled down

    Code
    =INDEX($A$1:$E$1,,MAX(IF(B16=$A$2:$E$13,COLUMN($A:$E)-MIN(COLUMN($A:$E))+1)))


    If you aren’t familiar with array-entered formulas array enter means the formula must be committed from edit mode by simultaneously pressing and holding down Ctrl and Shift while hitting Enter. (CSE for short.)

    And then this array-entered formula in D16 and filled across.

    Code
    =MAX(FREQUENCY(IF(D$15=$C$16:$C$35,ROW($16:$35)),IF(D$15<>$C$16:$C$35,ROW($16:$35))))



    [TABLE="class: grid"]

    [tr]


    [td]

    Row\Col

    [/td]


    [td]


    A


    [/td]


    [td]


    B


    [/td]


    [td]


    C


    [/td]


    [td]


    D


    [/td]


    [td]


    E


    [/td]


    [td]


    F


    [/td]


    [td]


    G


    [/td]


    [td]


    H


    [/td]


    [/tr]


    [tr]


    [td]


    1


    [/td]


    [td]


    A


    [/td]


    [td]


    B


    [/td]


    [td]


    C


    [/td]


    [td]


    D


    [/td]


    [td]


    E


    [/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [/tr]


    [tr]


    [td]


    2


    [/td]


    [td]


    1


    [/td]


    [td]


    2


    [/td]


    [td]


    3


    [/td]


    [td]


    37


    [/td]


    [td]


    38


    [/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [/tr]


    [tr]


    [td]


    3


    [/td]


    [td]


    4


    [/td]


    [td]


    5


    [/td]


    [td]


    6


    [/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [/tr]


    [tr]


    [td]


    4


    [/td]


    [td]


    7


    [/td]


    [td]


    8


    [/td]


    [td]


    9


    [/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [/tr]


    [tr]


    [td]


    5


    [/td]


    [td]


    10


    [/td]


    [td]


    11


    [/td]


    [td]


    12


    [/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [/tr]


    [tr]


    [td]


    6


    [/td]


    [td]


    13


    [/td]


    [td]


    14


    [/td]


    [td]


    15


    [/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [/tr]


    [tr]


    [td]


    7


    [/td]


    [td]


    16


    [/td]


    [td]


    17


    [/td]


    [td]


    18


    [/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [/tr]


    [tr]


    [td]


    8


    [/td]


    [td]


    19


    [/td]


    [td]


    20


    [/td]


    [td]


    21


    [/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [/tr]


    [tr]


    [td]


    9


    [/td]


    [td]


    22


    [/td]


    [td]


    23


    [/td]


    [td]


    24


    [/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [/tr]


    [tr]


    [td]


    10


    [/td]


    [td]


    25


    [/td]


    [td]


    26


    [/td]


    [td]


    27


    [/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [/tr]


    [tr]


    [td]


    11


    [/td]


    [td]


    28


    [/td]


    [td]


    29


    [/td]


    [td]


    30


    [/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [/tr]


    [tr]


    [td]


    12


    [/td]


    [td]


    31


    [/td]


    [td]


    32


    [/td]


    [td]


    33


    [/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [/tr]


    [tr]


    [td]


    13


    [/td]


    [td]


    34


    [/td]


    [td]


    35


    [/td]


    [td]


    36


    [/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [/tr]


    [tr]


    [td]


    14


    [/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [/tr]


    [tr]


    [td]


    15


    [/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td]


    A


    [/td]


    [td]


    B


    [/td]


    [td]


    C


    [/td]


    [td]


    D


    [/td]


    [td]


    E


    [/td]


    [/tr]


    [tr]


    [td]


    16


    [/td]


    [td]

    Row 1:

    [/td]


    [td]


    6


    [/td]


    [td]


    C


    [/td]


    [td]


    3


    [/td]


    [td]


    2


    [/td]


    [td]


    4


    [/td]


    [td]


    0


    [/td]


    [td]


    1


    [/td]


    [/tr]


    [tr]


    [td]


    17


    [/td]


    [td]

    Row 2:

    [/td]


    [td]


    7


    [/td]


    [td]


    A


    [/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [/tr]


    [tr]


    [td]


    18


    [/td]


    [td]

    Row 3:

    [/td]


    [td]


    2


    [/td]


    [td]


    B


    [/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [/tr]


    [tr]


    [td]


    19


    [/td]


    [td]

    Row 4:

    [/td]


    [td]


    34


    [/td]


    [td]


    A


    [/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [/tr]


    [tr]


    [td]


    20


    [/td]


    [td]

    Row 5:

    [/td]


    [td]


    15


    [/td]


    [td]


    C


    [/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [/tr]


    [tr]


    [td]


    21


    [/td]


    [td]

    Row 6:

    [/td]


    [td]


    36


    [/td]


    [td]


    C


    [/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [/tr]


    [tr]


    [td]


    22


    [/td]


    [td]

    Row 7:

    [/td]


    [td]


    21


    [/td]


    [td]


    C


    [/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [/tr]


    [tr]


    [td]


    23


    [/td]


    [td]

    Row 8:

    [/td]


    [td]


    12


    [/td]


    [td]


    C


    [/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [/tr]


    [tr]


    [td]


    24


    [/td]


    [td]

    Row 9:

    [/td]


    [td]


    38


    [/td]


    [td]


    E


    [/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [/tr]


    [tr]


    [td]


    25


    [/td]


    [td]

    Row 10:

    [/td]


    [td]


    33


    [/td]


    [td]


    C


    [/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [/tr]


    [tr]


    [td]


    26


    [/td]


    [td]

    Row 11:

    [/td]


    [td]


    1


    [/td]


    [td]


    A


    [/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [/tr]


    [tr]


    [td]


    27


    [/td]


    [td]

    Row 12:

    [/td]


    [td]


    7


    [/td]


    [td]


    A


    [/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [/tr]


    [tr]


    [td]


    28


    [/td]


    [td]

    Row 13:

    [/td]


    [td]


    4


    [/td]


    [td]


    A


    [/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [/tr]


    [tr]


    [td]


    29


    [/td]


    [td]

    Row 14:

    [/td]


    [td]


    18


    [/td]


    [td]


    C


    [/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [/tr]


    [tr]


    [td]


    30


    [/td]


    [td]

    Row 15:

    [/td]


    [td]


    15


    [/td]


    [td]


    C


    [/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [/tr]


    [tr]


    [td]


    31


    [/td]


    [td]

    Row 16:

    [/td]


    [td]


    28


    [/td]


    [td]


    A


    [/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [/tr]


    [tr]


    [td]


    32


    [/td]


    [td]

    Row 17:

    [/td]


    [td]


    29


    [/td]


    [td]


    B


    [/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [/tr]


    [tr]


    [td]


    33


    [/td]


    [td]

    Row 18:

    [/td]


    [td]


    23


    [/td]


    [td]


    B


    [/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [/tr]


    [tr]


    [td]


    34


    [/td]


    [td]

    Row 19:

    [/td]


    [td]


    4


    [/td]


    [td]


    A


    [/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [/tr]


    [tr]


    [td]


    35


    [/td]


    [td]

    Row 20:

    [/td]


    [td]


    26


    [/td]


    [td]


    B


    [/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [/tr]


    [/TABLE]