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

• ## Sum Area Based on Compound Row and Column Criteria

It sounds like the condition you speak of is IFERROR(long formula,""). That would trigger errors. Try IFERROR(long formula,[SIZE=14px]0[/SIZE])

• ## Sum Area Based on Compound Row and Column Criteria

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)``````
• ## Sum Area Based on Compound Row and Column Criteria

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

.

• ## Splitting Lines Based on Number of Units and Cost

Good deal! Thanks for the feedback and thanks for posting. I learned something new with this puzzle.

• ## Splitting Lines Based on Number of Units and Cost

If you have room for a helper column I have a work around for the volatility issue.

• ## Splitting Lines Based on Number of Units and Cost

I have to agree with Mumps. A sample is worth thousands of words.

• ## Splitting Lines Based on Number of Units and Cost

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?

• ## Splitting Lines Based on Number of Units and Cost

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

• ## Splitting Lines Based on Number of Units and Cost

Does this have to be VBA if it can be done by formula?

I have a formula solution.

• ## Name Box Shortcut Key

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

• ## Lookup Values in any column

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]

• ## Subtracting a number of months to a date

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?

• ## How To Extract Certain substring within a cell of Strings

Re: How To Extract Certain substring within a cell of Strings

If it doesn't have to be VBA this formula works on the example.

Assuming string is in A1.

Code
``=TRIM(MID(SUBSTITUTE(SUBSTITUTE(A1," ",REPT(" ",256),1),":",REPT(" ",256)),256,256))``
• ## Formatting dates

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.

• ## Formatting dates

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]

• ## Align several columns into 1 columns

Re: Align several columns into 1 columns

This would be another formula way without a helper column.

Code
``=IF(ROWS(\$5:5)>COUNTA(\$A\$1:\$C\$3),"",INDEX(\$A\$1:\$C\$3,MOD(ROWS(\$5:5),-3)+3,CEILING(ROWS(\$5:5)/3,1)))``
• ## Align several columns into 1 columns

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]

• ## Count the values by ignoring cells which contain NA

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

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.

• ## Combine if statement with 3 different return

Re: Combine if statement with 3 different return

Quote from S O;771542

This should do what you need:

=IF(OR(C5="",I5=""),"",IF(I5="F",7,SWITCH(WEEKDAY(C5),7,6,1,6,5)))

Is SWITCH a new 2016 function?

• ## Counting numbers that appear in succession over different columns

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]