compare data and extract

[edwinb]

Hi,
I need help from the expert!!!

Is there a way compare data (text in a cell) from wrksheet1 to worksheet2 then extract the data from wrksheet2 and paste it on wrksheet1? Here's the dilema; the text (cell) in the two worksheets that needed to be compared (or verified) are somewhat different. What I mean is that there will be commonality. The sample below show the worksheet have a common text; that is "mydata" and "data"...etc.

For example:
wrksheet2:
(cellA1)mydata_R1|(cellB1)12345.66
(A2)mydata_R2|(B2)23456.77
...
(A10)data_C111|(B10)34567.88
...
(A300)sync|(B300)456789.11

wrksheet1:
(C4)mydata|(D4)_____|(E4)______
(C5)data|(D5)_____|
...
(C200)sync|(D200)_____

Note: mydata and data are the text
_R1, _R2..._C111 are the reference designators (ref_des)

the "_" will be included in the text (cell) if a reference designator is present. There will be instances where there will not be ref_des.

Here's what needs to happen;
Using wrksheet1 as the reference, use the common text "mydata" in wrk1 as a "comparator" to locate it in wrksheet2. Once located and verified, the values of the common text "mydata" which are in cells B1 and B2 are then extracted and entered (or pasted/inserted) back to worksheet1, in this case in cells D4 and E4. Once that's done it goes to the next text "data" and repeats the same process untill all the values are extracted and entered in to wk1.
Here's another curve ball, if a ref_des is present in the text then it will need to be included in the values also and an "_" is added for separation.

The result should be something like this:

Final wrksheet1:
(C4)mydata|(D4)R1_12345.66|(E4)R2_23456.77
(C5)data|(D5)C111_34567.88
...
(C200)sync|(D200)456789.11

Can this be done? Please let me know if further clarification or more data is needed.

Thanks in advance,
Edwin B

Here's a portion of the wrksheets

sample1.xls
	A	B	C	D	E	F	G	H	I	J	K	L	M
1	worksheet1:	.	.	.	.	.	.	.	.	.	.	.	.
2	.	.	.	.	.	.	.	.	.	.	.	.	.
3	.	.	NameTag	Value	Value	Value	Value	Value	Value	Value	Value	Value	Value
4	.	.	mydata	.	.	.	.	.	.	.	.	.	.
5	.	.	data	.	.	.	.	.	.	.	.	.	.
6	.	.		.	.	.	.	.	.	.	.	.	.
7	.	.	sync	.	.	.	.	.	.	.	.	.	.
8	.	.	clk	.	.	.	.	.	.	.	.	.	.
9	.	.	bus	.	.	.	.	.	.	.	.	.	.
Sheet1

sample1.xls
	A	B	C	D	E	F
1	mydata_R1	12345.660	.	.	.	.
2	mydata_R2	23456.770	.	.	.	.
3	mydata_R3	654.000	.	.	.	.
4	mydata_R4	56444.000	.	.	.	.
5	mydata_R5	4456.000	.	.	.	.
6	mydata_R6	466.220	.	.	.	.
7	mydata_R7	5465.200	.	.	.	.
8	mydata_R8	5555.230	.	.	.	.
9	mydata_R9	56483.200	.	.	.	.
10	data_C111	34567.880	.	.	.	.
11	data_C112	5645.326	.	.	.	.
12	data_C113	55454.200	.	.	.	.
13			.	.	.	.
14	sync	5465865.215	.	.	.	.
15	clk	524.230	.	.	.	.
16	bus	252.325	.	.	.	.
Sheet2

 

[NBVC]

Check out this post I recently replied to.

You could probably adapt it to your needs.

http://www.mrexcel.com/board2/viewtopic.php?t=179906

 

[edwinb]

Hi NBVC,
Thanks again for a quick reply to my question.
I will try your suggestion and will let you know the outcome.

Regards,
Edwin B.

 

[edwinb]

Hi NBVC,
It looks like the extraction formula in the suggested link will not work for the reason that the text called "Developement" was in the formula. In my worksheet, there are hundreds of different text I need to compare (or verify) from the two worksheets. In my sample, "mydata, data, sync" are just some of them. It will take a lot of time to type each one of the text in the formula cell. Is there a VBA that you can think of that can do the task effeciently?

Thanks again in advance,
Edwin B

 

[NBVC]

That was specific that poster's requirement.

Just replace each occurrence of the word with the cell reference to what you're looking up in your sheet. You will need to adjust arrays and such too to match.

If you can post an HTML version of your sheet and what you are after, then perhaps, I can help with the exact formula you need.

Use Colo's HTML maker through the link at the bottom of this page.

 

[edwinb]

Final worksheet that I'm looking for:

Book1
	A	B	C	D	E	F	G	H	I
1	Final_Worksheet1	.	.	.	.	.	.	.	.
2	.	.	.	.	.	.	.	.	.
3	.	Name_tag	Value	Value	Value	Value	Value	Value	Value
4	.	mydata	R1_12345.660	R2_23456.77	R3_654	R4_56444	R5_4456	R6_466.22	R7_5465.2
5	.	data	C111_34567.88	C112_5645.326	C113_55454.2	.	.	.	.
6	.		.	.	.	.	.	.	.
7	.	sync	5465865.215	.	.	.	.	.	.
8	.	clk	524.23	.	.	.	.	.	.
9	.	bus	252.325	.	.	.	.	.	.
Sheet1

 

[NBVC]

<SCRIPT language=JavaScript src="http://www.interq.or.jp/sun/puremis/colo/popup.js"></SCRIPT><CENTER><TABLE align=center cellPadding=0 cellSpacing=0><TBODY><TR><TD bgColor=#0c266b colSpan=14 style="BORDER-LEFT: #000000 0.5pt solid; BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid"><TABLE align=center border=0 width="100%"><TBODY><TR><TD align=left><FONT color=white>Microsoft Excel - indextranspose.xls</FONT></TD><TD align=right style="COLOR: #ffffff; FONT-FAMILY: caption; FONT-SIZE: 9pt">___Running: 11.0 : OS = Windows Windows 2000 </FONT></TD></TR></TBODY></TABLE></TD></TR><TR><TD bgColor=#d4d0c8 colSpan=14 style="BORDER-LEFT: #000000 0.5pt solid; BORDER-RIGHT: #000000 0.5pt solid; HEIGHT: 25px"><TABLE align=center border=0 width="100%" VALIGN="MIDDLE"><TBODY><TR><TD style="COLOR: #000000; FONT-FAMILY: caption; FONT-SIZE: 10pt">(<U>F</U>)ile (<U>E</U>)dit (<U>V</U>)iew (<U>I</U>)nsert (<U>O</U>)ptions (<U>T</U>)ools (<U>D</U>)ata (<U>W</U>)indow (<U>H</U>)elp (<U>A</U>)bout</TD><TD align=right vAlign=center><FORM name=formCb755237><INPUT name=btCb873980 onclick='window.clipboardData.setData("Text",document.formFb078704.sltNb935705.value);' type=button value="Copy Formula"></FORM></TD></TR></TBODY></TABLE></TD></TR><TR><TD bgColor=white colSpan=14 style="BORDER-LEFT: #000000 0.5pt solid; BORDER-RIGHT: #000000 0.5pt solid"><TABLE border=0><TBODY><TR><FORM name=formFb078704><TD align=middle bgColor=white style="WIDTH: 60px"><SELECT name=sltNb935705 onchange="document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value"><OPTION selected value='=IF(ISERROR(FIND("_",Sheet2!$A1)),Sheet2!$A1,LEFT(Sheet2!$A1,FIND("_",Sheet2!$A1)-1))'>A1<OPTION value='=IF(ISERROR(FIND("_",Sheet2!A1)),Sheet2!B1,RIGHT(Sheet2!A1,LEN(Sheet2!A1)-FIND("_",Sheet2!A1))&"_"&Sheet2!B1)'>B1<OPTION value='=IF(ISERROR(FIND("_",Sheet2!$A2)),Sheet2!$A2,LEFT(Sheet2!$A2,FIND("_",Sheet2!$A2)-1))'>A2<OPTION value='=IF(ISERROR(FIND("_",Sheet2!A2)),Sheet2!B2,RIGHT(Sheet2!A2,LEN(Sheet2!A2)-FIND("_",Sheet2!A2))&"_"&Sheet2!B2)'>B2<OPTION value='=IF(ISERROR(FIND("_",Sheet2!$A3)),Sheet2!$A3,LEFT(Sheet2!$A3,FIND("_",Sheet2!$A3)-1))'>A3<OPTION value='=IF(ISERROR(FIND("_",Sheet2!A3)),Sheet2!B3,RIGHT(Sheet2!A3,LEN(Sheet2!A3)-FIND("_",Sheet2!A3))&"_"&Sheet2!B3)'>B3<OPTION value='=IF(ISERROR(FIND("_",Sheet2!$A4)),Sheet2!$A4,LEFT(Sheet2!$A4,FIND("_",Sheet2!$A4)-1))'>A4<OPTION value='=IF(ISERROR(FIND("_",Sheet2!A4)),Sheet2!B4,RIGHT(Sheet2!A4,LEN(Sheet2!A4)-FIND("_",Sheet2!A4))&"_"&Sheet2!B4)'>B4<OPTION value='{=IF(ROW(INDIRECT("A"&COLUMN(B2)))-ROW($A$1)>COUNTIF($A$1:$A$100,$C4),"",INDEX($B$1:$B$100,SMALL(IF($A$1:$A$100=$C4,ROW($A$1:$A$100)),ROW(INDIRECT("A"&COLUMN(B2)))-ROW($A$1))))}'>D4<OPTION value='{=IF(ROW(INDIRECT("A"&COLUMN(C2)))-ROW($A$1)>COUNTIF($A$1:$A$100,$C4),"",INDEX($B$1:$B$100,SMALL(IF($A$1:$A$100=$C4,ROW($A$1:$A$100)),ROW(INDIRECT("A"&COLUMN(C2)))-ROW($A$1))))}'>E4<OPTION value='{=IF(ROW(INDIRECT("A"&COLUMN(D2)))-ROW($A$1)>COUNTIF($A$1:$A$100,$C4),"",INDEX($B$1:$B$100,SMALL(IF($A$1:$A$100=$C4,ROW($A$1:$A$100)),ROW(INDIRECT("A"&COLUMN(D2)))-ROW($A$1))))}'>F4<OPTION value='{=IF(ROW(INDIRECT("A"&COLUMN(E2)))-ROW($A$1)>COUNTIF($A$1:$A$100,$C4),"",INDEX($B$1:$B$100,SMALL(IF($A$1:$A$100=$C4,ROW($A$1:$A$100)),ROW(INDIRECT("A"&COLUMN(E2)))-ROW($A$1))))}'>G4<OPTION value='{=IF(ROW(INDIRECT("A"&COLUMN(F2)))-ROW($A$1)>COUNTIF($A$1:$A$100,$C4),"",INDEX($B$1:$B$100,SMALL(IF($A$1:$A$100=$C4,ROW($A$1:$A$100)),ROW(INDIRECT("A"&COLUMN(F2)))-ROW($A$1))))}'>H4<OPTION value='{=IF(ROW(INDIRECT("A"&COLUMN(G2)))-ROW($A$1)>COUNTIF($A$1:$A$100,$C4),"",INDEX($B$1:$B$100,SMALL(IF($A$1:$A$100=$C4,ROW($A$1:$A$100)),ROW(INDIRECT("A"&COLUMN(G2)))-ROW($A$1))))}'>I4<OPTION value='{=IF(ROW(INDIRECT("A"&COLUMN(H2)))-ROW($A$1)>COUNTIF($A$1:$A$100,$C4),"",INDEX($B$1:$B$100,SMALL(IF($A$1:$A$100=$C4,ROW($A$1:$A$100)),ROW(INDIRECT("A"&COLUMN(H2)))-ROW($A$1))))}'>J4<OPTION value='{=IF(ROW(INDIRECT("A"&COLUMN(I2)))-ROW($A$1)>COUNTIF($A$1:$A$100,$C4),"",INDEX($B$1:$B$100,SMALL(IF($A$1:$A$100=$C4,ROW($A$1:$A$100)),ROW(INDIRECT("A"&COLUMN(I2)))-ROW($A$1))))}'>K4<OPTION value='{=IF(ROW(INDIRECT("A"&COLUMN(J2)))-ROW($A$1)>COUNTIF($A$1:$A$100,$C4),"",INDEX($B$1:$B$100,SMALL(IF($A$1:$A$100=$C4,ROW($A$1:$A$100)),ROW(INDIRECT("A"&COLUMN(J2)))-ROW($A$1))))}'>L4<OPTION value='{=IF(ROW(INDIRECT("A"&COLUMN(K2)))-ROW($A$1)>COUNTIF($A$1:$A$100,$C4),"",INDEX($B$1:$B$100,SMALL(IF($A$1:$A$100=$C4,ROW($A$1:$A$100)),ROW(INDIRECT("A"&COLUMN(K2)))-ROW($A$1))))}'>M4<OPTION value='=IF(ISERROR(FIND("_",Sheet2!$A5)),Sheet2!$A5,LEFT(Sheet2!$A5,FIND("_",Sheet2!$A5)-1))'>A5<OPTION value='=IF(ISERROR(FIND("_",Sheet2!A5)),Sheet2!B5,RIGHT(Sheet2!A5,LEN(Sheet2!A5)-FIND("_",Sheet2!A5))&"_"&Sheet2!B5)'>B5<OPTION value='{=IF(ROW(INDIRECT("A"&COLUMN(B3)))-ROW($A$1)>COUNTIF($A$1:$A$100,$C5),"",INDEX($B$1:$B$100,SMALL(IF($A$1:$A$100=$C5,ROW($A$1:$A$100)),ROW(INDIRECT("A"&COLUMN(B3)))-ROW($A$1))))}'>D5<OPTION value='{=IF(ROW(INDIRECT("A"&COLUMN(C3)))-ROW($A$1)>COUNTIF($A$1:$A$100,$C5),"",INDEX($B$1:$B$100,SMALL(IF($A$1:$A$100=$C5,ROW($A$1:$A$100)),ROW(INDIRECT("A"&COLUMN(C3)))-ROW($A$1))))}'>E5<OPTION value='{=IF(ROW(INDIRECT("A"&COLUMN(D3)))-ROW($A$1)>COUNTIF($A$1:$A$100,$C5),"",INDEX($B$1:$B$100,SMALL(IF($A$1:$A$100=$C5,ROW($A$1:$A$100)),ROW(INDIRECT("A"&COLUMN(D3)))-ROW($A$1))))}'>F5<OPTION value='{=IF(ROW(INDIRECT("A"&COLUMN(E3)))-ROW($A$1)>COUNTIF($A$1:$A$100,$C5),"",INDEX($B$1:$B$100,SMALL(IF($A$1:$A$100=$C5,ROW($A$1:$A$100)),ROW(INDIRECT("A"&COLUMN(E3)))-ROW($A$1))))}'>G5<OPTION value='{=IF(ROW(INDIRECT("A"&COLUMN(F3)))-ROW($A$1)>COUNTIF($A$1:$A$100,$C5),"",INDEX($B$1:$B$100,SMALL(IF($A$1:$A$100=$C5,ROW($A$1:$A$100)),ROW(INDIRECT("A"&COLUMN(F3)))-ROW($A$1))))}'>H5<OPTION value='{=IF(ROW(INDIRECT("A"&COLUMN(G3)))-ROW($A$1)>COUNTIF($A$1:$A$100,$C5),"",INDEX($B$1:$B$100,SMALL(IF($A$1:$A$100=$C5,ROW($A$1:$A$100)),ROW(INDIRECT("A"&COLUMN(G3)))-ROW($A$1))))}'>I5<OPTION value='{=IF(ROW(INDIRECT("A"&COLUMN(H3)))-ROW($A$1)>COUNTIF($A$1:$A$100,$C5),"",INDEX($B$1:$B$100,SMALL(IF($A$1:$A$100=$C5,ROW($A$1:$A$100)),ROW(INDIRECT("A"&COLUMN(H3)))-ROW($A$1))))}'>J5<OPTION value='{=IF(ROW(INDIRECT("A"&COLUMN(I3)))-ROW($A$1)>COUNTIF($A$1:$A$100,$C5),"",INDEX($B$1:$B$100,SMALL(IF($A$1:$A$100=$C5,ROW($A$1:$A$100)),ROW(INDIRECT("A"&COLUMN(I3)))-ROW($A$1))))}'>K5<OPTION value='{=IF(ROW(INDIRECT("A"&COLUMN(J3)))-ROW($A$1)>COUNTIF($A$1:$A$100,$C5),"",INDEX($B$1:$B$100,SMALL(IF($A$1:$A$100=$C5,ROW($A$1:$A$100)),ROW(INDIRECT("A"&COLUMN(J3)))-ROW($A$1))))}'>L5<OPTION value='{=IF(ROW(INDIRECT("A"&COLUMN(K3)))-ROW($A$1)>COUNTIF($A$1:$A$100,$C5),"",INDEX($B$1:$B$100,SMALL(IF($A$1:$A$100=$C5,ROW($A$1:$A$100)),ROW(INDIRECT("A"&COLUMN(K3)))-ROW($A$1))))}'>M5<OPTION value='=IF(ISERROR(FIND("_",Sheet2!$A6)),Sheet2!$A6,LEFT(Sheet2!$A6,FIND("_",Sheet2!$A6)-1))'>A6<OPTION value='=IF(ISERROR(FIND("_",Sheet2!A6)),Sheet2!B6,RIGHT(Sheet2!A6,LEN(Sheet2!A6)-FIND("_",Sheet2!A6))&"_"&Sheet2!B6)'>B6<OPTION value='{=IF(ROW(INDIRECT("A"&COLUMN(B4)))-ROW($A$1)>COUNTIF($A$1:$A$100,$C6),"",INDEX($B$1:$B$100,SMALL(IF($A$1:$A$100=$C6,ROW($A$1:$A$100)),ROW(INDIRECT("A"&COLUMN(B4)))-ROW($A$1))))}'>D6<OPTION value='{=IF(ROW(INDIRECT("A"&COLUMN(C4)))-ROW($A$1)>COUNTIF($A$1:$A$100,$C6),"",INDEX($B$1:$B$100,SMALL(IF($A$1:$A$100=$C6,ROW($A$1:$A$100)),ROW(INDIRECT("A"&COLUMN(C4)))-ROW($A$1))))}'>E6<OPTION value='{=IF(ROW(INDIRECT("A"&COLUMN(D4)))-ROW($A$1)>COUNTIF($A$1:$A$100,$C6),"",INDEX($B$1:$B$100,SMALL(IF($A$1:$A$100=$C6,ROW($A$1:$A$100)),ROW(INDIRECT("A"&COLUMN(D4)))-ROW($A$1))))}'>F6<OPTION value='{=IF(ROW(INDIRECT("A"&COLUMN(E4)))-ROW($A$1)>COUNTIF($A$1:$A$100,$C6),"",INDEX($B$1:$B$100,SMALL(IF($A$1:$A$100=$C6,ROW($A$1:$A$100)),ROW(INDIRECT("A"&COLUMN(E4)))-ROW($A$1))))}'>G6<OPTION value='{=IF(ROW(INDIRECT("A"&COLUMN(F4)))-ROW($A$1)>COUNTIF($A$1:$A$100,$C6),"",INDEX($B$1:$B$100,SMALL(IF($A$1:$A$100=$C6,ROW($A$1:$A$100)),ROW(INDIRECT("A"&COLUMN(F4)))-ROW($A$1))))}'>H6<OPTION value='{=IF(ROW(INDIRECT("A"&COLUMN(G4)))-ROW($A$1)>COUNTIF($A$1:$A$100,$C6),"",INDEX($B$1:$B$100,SMALL(IF($A$1:$A$100=$C6,ROW($A$1:$A$100)),ROW(INDIRECT("A"&COLUMN(G4)))-ROW($A$1))))}'>I6<OPTION value='{=IF(ROW(INDIRECT("A"&COLUMN(H4)))-ROW($A$1)>COUNTIF($A$1:$A$100,$C6),"",INDEX($B$1:$B$100,SMALL(IF($A$1:$A$100=$C6,ROW($A$1:$A$100)),ROW(INDIRECT("A"&COLUMN(H4)))-ROW($A$1))))}'>J6<OPTION value='{=IF(ROW(INDIRECT("A"&COLUMN(I4)))-ROW($A$1)>COUNTIF($A$1:$A$100,$C6),"",INDEX($B$1:$B$100,SMALL(IF($A$1:$A$100=$C6,ROW($A$1:$A$100)),ROW(INDIRECT("A"&COLUMN(I4)))-ROW($A$1))))}'>K6<OPTION value='{=IF(ROW(INDIRECT("A"&COLUMN(J4)))-ROW($A$1)>COUNTIF($A$1:$A$100,$C6),"",INDEX($B$1:$B$100,SMALL(IF($A$1:$A$100=$C6,ROW($A$1:$A$100)),ROW(INDIRECT("A"&COLUMN(J4)))-ROW($A$1))))}'>L6<OPTION value='{=IF(ROW(INDIRECT("A"&COLUMN(K4)))-ROW($A$1)>COUNTIF($A$1:$A$100,$C6),"",INDEX($B$1:$B$100,SMALL(IF($A$1:$A$100=$C6,ROW($A$1:$A$100)),ROW(INDIRECT("A"&COLUMN(K4)))-ROW($A$1))))}'>M6<OPTION value='=IF(ISERROR(FIND("_",Sheet2!$A7)),Sheet2!$A7,LEFT(Sheet2!$A7,FIND("_",Sheet2!$A7)-1))'>A7<OPTION value='=IF(ISERROR(FIND("_",Sheet2!A7)),Sheet2!B7,RIGHT(Sheet2!A7,LEN(Sheet2!A7)-FIND("_",Sheet2!A7))&"_"&Sheet2!B7)'>B7<OPTION value='{=IF(ROW(INDIRECT("A"&COLUMN(B5)))-ROW($A$1)>COUNTIF($A$1:$A$100,$C7),"",INDEX($B$1:$B$100,SMALL(IF($A$1:$A$100=$C7,ROW($A$1:$A$100)),ROW(INDIRECT("A"&COLUMN(B5)))-ROW($A$1))))}'>D7<OPTION value='{=IF(ROW(INDIRECT("A"&COLUMN(C5)))-ROW($A$1)>COUNTIF($A$1:$A$100,$C7),"",INDEX($B$1:$B$100,SMALL(IF($A$1:$A$100=$C7,ROW($A$1:$A$100)),ROW(INDIRECT("A"&COLUMN(C5)))-ROW($A$1))))}'>E7<OPTION value='{=IF(ROW(INDIRECT("A"&COLUMN(D5)))-ROW($A$1)>COUNTIF($A$1:$A$100,$C7),"",INDEX($B$1:$B$100,SMALL(IF($A$1:$A$100=$C7,ROW($A$1:$A$100)),ROW(INDIRECT("A"&COLUMN(D5)))-ROW($A$1))))}'>F7<OPTION value='{=IF(ROW(INDIRECT("A"&COLUMN(E5)))-ROW($A$1)>COUNTIF($A$1:$A$100,$C7),"",INDEX($B$1:$B$100,SMALL(IF($A$1:$A$100=$C7,ROW($A$1:$A$100)),ROW(INDIRECT("A"&COLUMN(E5)))-ROW($A$1))))}'>G7<OPTION value='{=IF(ROW(INDIRECT("A"&COLUMN(F5)))-ROW($A$1)>COUNTIF($A$1:$A$100,$C7),"",INDEX($B$1:$B$100,SMALL(IF($A$1:$A$100=$C7,ROW($A$1:$A$100)),ROW(INDIRECT("A"&COLUMN(F5)))-ROW($A$1))))}'>H7<OPTION value='{=IF(ROW(INDIRECT("A"&COLUMN(G5)))-ROW($A$1)>COUNTIF($A$1:$A$100,$C7),"",INDEX($B$1:$B$100,SMALL(IF($A$1:$A$100=$C7,ROW($A$1:$A$100)),ROW(INDIRECT("A"&COLUMN(G5)))-ROW($A$1))))}'>I7<OPTION value='{=IF(ROW(INDIRECT("A"&COLUMN(H5)))-ROW($A$1)>COUNTIF($A$1:$A$100,$C7),"",INDEX($B$1:$B$100,SMALL(IF($A$1:$A$100=$C7,ROW($A$1:$A$100)),ROW(INDIRECT("A"&COLUMN(H5)))-ROW($A$1))))}'>J7<OPTION value='{=IF(ROW(INDIRECT("A"&COLUMN(I5)))-ROW($A$1)>COUNTIF($A$1:$A$100,$C7),"",INDEX($B$1:$B$100,SMALL(IF($A$1:$A$100=$C7,ROW($A$1:$A$100)),ROW(INDIRECT("A"&COLUMN(I5)))-ROW($A$1))))}'>K7<OPTION value='{=IF(ROW(INDIRECT("A"&COLUMN(J5)))-ROW($A$1)>COUNTIF($A$1:$A$100,$C7),"",INDEX($B$1:$B$100,SMALL(IF($A$1:$A$100=$C7,ROW($A$1:$A$100)),ROW(INDIRECT("A"&COLUMN(J5)))-ROW($A$1))))}'>L7<OPTION value='{=IF(ROW(INDIRECT("A"&COLUMN(K5)))-ROW($A$1)>COUNTIF($A$1:$A$100,$C7),"",INDEX($B$1:$B$100,SMALL(IF($A$1:$A$100=$C7,ROW($A$1:$A$100)),ROW(INDIRECT("A"&COLUMN(K5)))-ROW($A$1))))}'>M7<OPTION value='=IF(ISERROR(FIND("_",Sheet2!$A8)),Sheet2!$A8,LEFT(Sheet2!$A8,FIND("_",Sheet2!$A8)-1))'>A8<OPTION value='=IF(ISERROR(FIND("_",Sheet2!A8)),Sheet2!B8,RIGHT(Sheet2!A8,LEN(Sheet2!A8)-FIND("_",Sheet2!A8))&"_"&Sheet2!B8)'>B8<OPTION value='{=IF(ROW(INDIRECT("A"&COLUMN(B6)))-ROW($A$1)>COUNTIF($A$1:$A$100,$C8),"",INDEX($B$1:$B$100,SMALL(IF($A$1:$A$100=$C8,ROW($A$1:$A$100)),ROW(INDIRECT("A"&COLUMN(B6)))-ROW($A$1))))}'>D8<OPTION value='{=IF(ROW(INDIRECT("A"&COLUMN(C6)))-ROW($A$1)>COUNTIF($A$1:$A$100,$C8),"",INDEX($B$1:$B$100,SMALL(IF($A$1:$A$100=$C8,ROW($A$1:$A$100)),ROW(INDIRECT("A"&COLUMN(C6)))-ROW($A$1))))}'>E8<OPTION value='{=IF(ROW(INDIRECT("A"&COLUMN(D6)))-ROW($A$1)>COUNTIF($A$1:$A$100,$C8),"",INDEX($B$1:$B$100,SMALL(IF($A$1:$A$100=$C8,ROW($A$1:$A$100)),ROW(INDIRECT("A"&COLUMN(D6)))-ROW($A$1))))}'>F8<OPTION value='{=IF(ROW(INDIRECT("A"&COLUMN(E6)))-ROW($A$1)>COUNTIF($A$1:$A$100,$C8),"",INDEX($B$1:$B$100,SMALL(IF($A$1:$A$100=$C8,ROW($A$1:$A$100)),ROW(INDIRECT("A"&COLUMN(E6)))-ROW($A$1))))}'>G8<OPTION value='{=IF(ROW(INDIRECT("A"&COLUMN(F6)))-ROW($A$1)>COUNTIF($A$1:$A$100,$C8),"",INDEX($B$1:$B$100,SMALL(IF($A$1:$A$100=$C8,ROW($A$1:$A$100)),ROW(INDIRECT("A"&COLUMN(F6)))-ROW($A$1))))}'>H8<OPTION value='{=IF(ROW(INDIRECT("A"&COLUMN(G6)))-ROW($A$1)>COUNTIF($A$1:$A$100,$C8),"",INDEX($B$1:$B$100,SMALL(IF($A$1:$A$100=$C8,ROW($A$1:$A$100)),ROW(INDIRECT("A"&COLUMN(G6)))-ROW($A$1))))}'>I8<OPTION value='{=IF(ROW(INDIRECT("A"&COLUMN(H6)))-ROW($A$1)>COUNTIF($A$1:$A$100,$C8),"",INDEX($B$1:$B$100,SMALL(IF($A$1:$A$100=$C8,ROW($A$1:$A$100)),ROW(INDIRECT("A"&COLUMN(H6)))-ROW($A$1))))}'>J8<OPTION value='{=IF(ROW(INDIRECT("A"&COLUMN(I6)))-ROW($A$1)>COUNTIF($A$1:$A$100,$C8),"",INDEX($B$1:$B$100,SMALL(IF($A$1:$A$100=$C8,ROW($A$1:$A$100)),ROW(INDIRECT("A"&COLUMN(I6)))-ROW($A$1))))}'>K8<OPTION value='{=IF(ROW(INDIRECT("A"&COLUMN(J6)))-ROW($A$1)>COUNTIF($A$1:$A$100,$C8),"",INDEX($B$1:$B$100,SMALL(IF($A$1:$A$100=$C8,ROW($A$1:$A$100)),ROW(INDIRECT("A"&COLUMN(J6)))-ROW($A$1))))}'>L8<OPTION value='{=IF(ROW(INDIRECT("A"&COLUMN(K6)))-ROW($A$1)>COUNTIF($A$1:$A$100,$C8),"",INDEX($B$1:$B$100,SMALL(IF($A$1:$A$100=$C8,ROW($A$1:$A$100)),ROW(INDIRECT("A"&COLUMN(K6)))-ROW($A$1))))}'>M8<OPTION value='=IF(ISERROR(FIND("_",Sheet2!$A9)),Sheet2!$A9,LEFT(Sheet2!$A9,FIND("_",Sheet2!$A9)-1))'>A9<OPTION value='=IF(ISERROR(FIND("_",Sheet2!A9)),Sheet2!B9,RIGHT(Sheet2!A9,LEN(Sheet2!A9)-FIND("_",Sheet2!A9))&"_"&Sheet2!B9)'>B9<OPTION value='=IF(ISERROR(FIND("_",Sheet2!$A10)),Sheet2!$A10,LEFT(Sheet2!$A10,FIND("_",Sheet2!$A10)-1))'>A10<OPTION value='=IF(ISERROR(FIND("_",Sheet2!A10)),Sheet2!B10,RIGHT(Sheet2!A10,LEN(Sheet2!A10)-FIND("_",Sheet2!A10))&"_"&Sheet2!B10)'>B10<OPTION value='=IF(ISERROR(FIND("_",Sheet2!$A11)),Sheet2!$A11,LEFT(Sheet2!$A11,FIND("_",Sheet2!$A11)-1))'>A11<OPTION value='=IF(ISERROR(FIND("_",Sheet2!A11)),Sheet2!B11,RIGHT(Sheet2!A11,LEN(Sheet2!A11)-FIND("_",Sheet2!A11))&"_"&Sheet2!B11)'>B11<OPTION value='=IF(ISERROR(FIND("_",Sheet2!$A12)),Sheet2!$A12,LEFT(Sheet2!$A12,FIND("_",Sheet2!$A12)-1))'>A12<OPTION value='=IF(ISERROR(FIND("_",Sheet2!A12)),Sheet2!B12,RIGHT(Sheet2!A12,LEN(Sheet2!A12)-FIND("_",Sheet2!A12))&"_"&Sheet2!B12)'>B12<OPTION value='=IF(ISERROR(FIND("_",Sheet2!$A13)),Sheet2!$A13,LEFT(Sheet2!$A13,FIND("_",Sheet2!$A13)-1))'>A13<OPTION value='=IF(ISERROR(FIND("_",Sheet2!A13)),Sheet2!B13,RIGHT(Sheet2!A13,LEN(Sheet2!A13)-FIND("_",Sheet2!A13))&"_"&Sheet2!B13)'>B13<OPTION value='=IF(ISERROR(FIND("_",Sheet2!$A14)),Sheet2!$A14,LEFT(Sheet2!$A14,FIND("_",Sheet2!$A14)-1))'>A14<OPTION value='=IF(ISERROR(FIND("_",Sheet2!A14)),Sheet2!B14,RIGHT(Sheet2!A14,LEN(Sheet2!A14)-FIND("_",Sheet2!A14))&"_"&Sheet2!B14)'>B14<OPTION value='=IF(ISERROR(FIND("_",Sheet2!$A15)),Sheet2!$A15,LEFT(Sheet2!$A15,FIND("_",Sheet2!$A15)-1))'>A15<OPTION value='=IF(ISERROR(FIND("_",Sheet2!A15)),Sheet2!B15,RIGHT(Sheet2!A15,LEN(Sheet2!A15)-FIND("_",Sheet2!A15))&"_"&Sheet2!B15)'>B15<OPTION value='=IF(ISERROR(FIND("_",Sheet2!$A16)),Sheet2!$A16,LEFT(Sheet2!$A16,FIND("_",Sheet2!$A16)-1))'>A16<OPTION value='=IF(ISERROR(FIND("_",Sheet2!A16)),Sheet2!B16,RIGHT(Sheet2!A16,LEN(Sheet2!A16)-FIND("_",Sheet2!A16))&"_"&Sheet2!B16)'>B16<OPTION value='=IF(ISERROR(FIND("_",Sheet2!$A17)),Sheet2!$A17,LEFT(Sheet2!$A17,FIND("_",Sheet2!$A17)-1))'>A17<OPTION value='=IF(ISERROR(FIND("_",Sheet2!A17)),Sheet2!B17,RIGHT(Sheet2!A17,LEN(Sheet2!A17)-FIND("_",Sheet2!A17))&"_"&Sheet2!B17)'>B17<OPTION value='=IF(ISERROR(FIND("_",Sheet2!$A18)),Sheet2!$A18,LEFT(Sheet2!$A18,FIND("_",Sheet2!$A18)-1))'>A18<OPTION value='=IF(ISERROR(FIND("_",Sheet2!A18)),Sheet2!B18,RIGHT(Sheet2!A18,LEN(Sheet2!A18)-FIND("_",Sheet2!A18))&"_"&Sheet2!B18)'>B18<OPTION value='=IF(ISERROR(FIND("_",Sheet2!$A19)),Sheet2!$A19,LEFT(Sheet2!$A19,FIND("_",Sheet2!$A19)-1))'>A19<OPTION value='=IF(ISERROR(FIND("_",Sheet2!A19)),Sheet2!B19,RIGHT(Sheet2!A19,LEN(Sheet2!A19)-FIND("_",Sheet2!A19))&"_"&Sheet2!B19)'>B19<OPTION value='=IF(ISERROR(FIND("_",Sheet2!$A20)),Sheet2!$A20,LEFT(Sheet2!$A20,FIND("_",Sheet2!$A20)-1))'>A20<OPTION value='=IF(ISERROR(FIND("_",Sheet2!A20)),Sheet2!B20,RIGHT(Sheet2!A20,LEN(Sheet2!A20)-FIND("_",Sheet2!A20))&"_"&Sheet2!B20)'>B20</OPTION></SELECT></TD><TD align=right bgColor=#d4d0c8 width="3%">=</TD><TD align=left bgColor=white><INPUT name=txbFb426622 size=80 value='=IF(ISERROR(FIND("_",Sheet2!$A1)),Sheet2!$A1,LEFT(Sheet2!$A1,FIND("_",Sheet2!$A1)-1))'></TD></FORM></TR></TBODY></TABLE></TD></TR><TR><TD align=middle style="BACKGROUND-COLOR: #d4d0c8; BORDER-LEFT: #000000 0.5pt solid; BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid" width="2%">
</TD><TD align=middle style="BACKGROUND-COLOR: #d4d0c8; BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; COLOR: black; FONT-FAMILY: menu; FONT-SIZE: 10pt"><CENTER>A</CENTER></TD><TD align=middle style="BACKGROUND-COLOR: #d4d0c8; BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; COLOR: black; FONT-FAMILY: menu; FONT-SIZE: 10pt"><CENTER>B</CENTER></TD><TD align=middle style="BACKGROUND-COLOR: #d4d0c8; BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; COLOR: black; FONT-FAMILY: menu; FONT-SIZE: 10pt"><CENTER>C</CENTER></TD><TD align=middle style="BACKGROUND-COLOR: #d4d0c8; BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; COLOR: black; FONT-FAMILY: menu; FONT-SIZE: 10pt"><CENTER>D</CENTER></TD><TD align=middle style="BACKGROUND-COLOR: #d4d0c8; BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; COLOR: black; FONT-FAMILY: menu; FONT-SIZE: 10pt"><CENTER>E</CENTER></TD><TD align=middle style="BACKGROUND-COLOR: #d4d0c8; BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; COLOR: black; FONT-FAMILY: menu; FONT-SIZE: 10pt"><CENTER>F</CENTER></TD><TD align=middle style="BACKGROUND-COLOR: #d4d0c8; BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; COLOR: black; FONT-FAMILY: menu; FONT-SIZE: 10pt"><CENTER>G</CENTER></TD><TD align=middle style="BACKGROUND-COLOR: #d4d0c8; BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; COLOR: black; FONT-FAMILY: menu; FONT-SIZE: 10pt"><CENTER>H</CENTER></TD><TD align=middle style="BACKGROUND-COLOR: #d4d0c8; BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; COLOR: black; FONT-FAMILY: menu; FONT-SIZE: 10pt"><CENTER>I</CENTER></TD><TD align=middle style="BACKGROUND-COLOR: #d4d0c8; BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; COLOR: black; FONT-FAMILY: menu; FONT-SIZE: 10pt"><CENTER>J</CENTER></TD><TD align=middle style="BACKGROUND-COLOR: #d4d0c8; BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; COLOR: black; FONT-FAMILY: menu; FONT-SIZE: 10pt"><CENTER>K</CENTER></TD><TD align=middle style="BACKGROUND-COLOR: #d4d0c8; BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; COLOR: black; FONT-FAMILY: menu; FONT-SIZE: 10pt"><CENTER>L</CENTER></TD><TD align=middle style="BACKGROUND-COLOR: #d4d0c8; BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; COLOR: black; FONT-FAMILY: menu; FONT-SIZE: 10pt"><CENTER>M</CENTER></TD></TR><TR><TD align=middle style="BACKGROUND-COLOR: #d4d0c8; BORDER-LEFT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; FONT-SIZE: 10pt" width="2%"><CENTER>1</CENTER></TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: left; VERTICAL-ALIGN: bottom">mydata</FONT></TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #000000 2pt solid; BORDER-TOP: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: left; VERTICAL-ALIGN: bottom">R1_12345.66</FONT></TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom"> </TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom"> </TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom"> </TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom"> </TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom"> </TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom"> </TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom"> </TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom"> </TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom"> </TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom"> </TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom"> </TD></TR><TR><TD align=middle style="BACKGROUND-COLOR: #d4d0c8; BORDER-LEFT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; FONT-SIZE: 10pt" width="2%"><CENTER>2</CENTER></TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: left; VERTICAL-ALIGN: bottom">mydata</FONT></TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #000000 2pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: left; VERTICAL-ALIGN: bottom">R2_23456.77</FONT></TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom"> </TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom"> </TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom"> </TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom"> </TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom"> </TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom"> </TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom"> </TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom"> </TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom"> </TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom"> </TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom"> </TD></TR><TR><TD align=middle style="BACKGROUND-COLOR: #d4d0c8; BORDER-LEFT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; FONT-SIZE: 10pt" width="2%"><CENTER>3</CENTER></TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: left; VERTICAL-ALIGN: bottom">mydata</FONT></TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #000000 2pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: left; VERTICAL-ALIGN: bottom">R3_654</FONT></TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold; TEXT-ALIGN: center; VERTICAL-ALIGN: bottom">Name_tag</TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom">Value</TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom">Value</TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom">Value</TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom">Value</TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom">Value</TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom">Value</TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom">Value</TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom">Value</TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom">Value</TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom"> </TD></TR><TR><TD align=middle style="BACKGROUND-COLOR: #d4d0c8; BORDER-LEFT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; FONT-SIZE: 10pt" width="2%"><CENTER>4</CENTER></TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: left; VERTICAL-ALIGN: bottom">mydata</FONT></TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #000000 2pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: left; VERTICAL-ALIGN: bottom">R4_56444</FONT></TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: left; VERTICAL-ALIGN: bottom">mydata</TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom">R1_12345.66</FONT></TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom">R2_23456.77</FONT></TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom">R3_654</FONT></TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom">R4_56444</FONT></TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom">R5_4456</FONT></TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom">R6_466.22</FONT></TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom">R7_5465.2</FONT></TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom">R8_5555.23</FONT></TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom">R9_56483.2</FONT></TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: left; VERTICAL-ALIGN: bottom"><A href="#javascript:void(0);" onclick="document.formFb078704.sltNb935705.options[17].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;">
</FONT></A></TD></TR><TR><TD align=middle style="BACKGROUND-COLOR: #d4d0c8; BORDER-LEFT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; FONT-SIZE: 10pt" width="2%"><CENTER>5</CENTER></TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: left; VERTICAL-ALIGN: bottom">mydata</FONT></TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #000000 2pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: left; VERTICAL-ALIGN: bottom">R5_4456</FONT></TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: left; VERTICAL-ALIGN: bottom">data</TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom">c111_34567.88</FONT></TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom">c112_5645.326</FONT></TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom">c113_5545.22</FONT></TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom">c114_56444</FONT></TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom">c115_4456</FONT></TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom">c116_466.22</FONT></TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom">c117_5465.2</FONT></TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom">c118_5645.326</FONT></TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom"><A href="#javascript:void(0);" onclick="document.formFb078704.sltNb935705.options[28].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;">
</FONT></A></TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: left; VERTICAL-ALIGN: bottom"><A href="#javascript:void(0);" onclick="document.formFb078704.sltNb935705.options[29].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;">
</FONT></A></TD></TR><TR><TD align=middle style="BACKGROUND-COLOR: #d4d0c8; BORDER-LEFT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; FONT-SIZE: 10pt" width="2%"><CENTER>6</CENTER></TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: left; VERTICAL-ALIGN: bottom">mydata</FONT></TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #000000 2pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: left; VERTICAL-ALIGN: bottom">R6_466.22</FONT></TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: left; VERTICAL-ALIGN: bottom">sync</TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom">5465865.215</FONT></TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom"><A href="#javascript:void(0);" onclick="document.formFb078704.sltNb935705.options[33].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;">
</FONT></A></TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom"><A href="#javascript:void(0);" onclick="document.formFb078704.sltNb935705.options[34].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;">
</FONT></A></TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom"><A href="#javascript:void(0);" onclick="document.formFb078704.sltNb935705.options[35].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;">
</FONT></A></TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom"><A href="#javascript:void(0);" onclick="document.formFb078704.sltNb935705.options[36].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;">
</FONT></A></TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom"><A href="#javascript:void(0);" onclick="document.formFb078704.sltNb935705.options[37].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;">
</FONT></A></TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom"><A href="#javascript:void(0);" onclick="document.formFb078704.sltNb935705.options[38].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;">
</FONT></A></TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom"><A href="#javascript:void(0);" onclick="document.formFb078704.sltNb935705.options[39].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;">
</FONT></A></TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom"><A href="#javascript:void(0);" onclick="document.formFb078704.sltNb935705.options[40].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;">
</FONT></A></TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: left; VERTICAL-ALIGN: bottom"><A href="#javascript:void(0);" onclick="document.formFb078704.sltNb935705.options[41].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;">
</FONT></A></TD></TR><TR><TD align=middle style="BACKGROUND-COLOR: #d4d0c8; BORDER-LEFT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; FONT-SIZE: 10pt" width="2%"><CENTER>7</CENTER></TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: left; VERTICAL-ALIGN: bottom">mydata</FONT></TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #000000 2pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: left; VERTICAL-ALIGN: bottom">R7_5465.2</FONT></TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: left; VERTICAL-ALIGN: bottom">clk</TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom">524.23</FONT></TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom"><A href="#javascript:void(0);" onclick="document.formFb078704.sltNb935705.options[45].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;">
</FONT></A></TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom"><A href="#javascript:void(0);" onclick="document.formFb078704.sltNb935705.options[46].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;">
</FONT></A></TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom"><A href="#javascript:void(0);" onclick="document.formFb078704.sltNb935705.options[47].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;">
</FONT></A></TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom"><A href="#javascript:void(0);" onclick="document.formFb078704.sltNb935705.options[48].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;">
</FONT></A></TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom"><A href="#javascript:void(0);" onclick="document.formFb078704.sltNb935705.options[49].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;">
</FONT></A></TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom"><A href="#javascript:void(0);" onclick="document.formFb078704.sltNb935705.options[50].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;">
</FONT></A></TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom"><A href="#javascript:void(0);" onclick="document.formFb078704.sltNb935705.options[51].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;">
</FONT></A></TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom"><A href="#javascript:void(0);" onclick="document.formFb078704.sltNb935705.options[52].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;">
</FONT></A></TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: left; VERTICAL-ALIGN: bottom"><A href="#javascript:void(0);" onclick="document.formFb078704.sltNb935705.options[53].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;">
</FONT></A></TD></TR><TR><TD align=middle style="BACKGROUND-COLOR: #d4d0c8; BORDER-LEFT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; FONT-SIZE: 10pt" width="2%"><CENTER>8</CENTER></TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: left; VERTICAL-ALIGN: bottom">mydata</FONT></TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #000000 2pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: left; VERTICAL-ALIGN: bottom">R8_5555.23</FONT></TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: left; VERTICAL-ALIGN: bottom">bus</TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom">252.325</FONT></TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom"><A href="#javascript:void(0);" onclick="document.formFb078704.sltNb935705.options[57].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;">
</FONT></A></TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom"><A href="#javascript:void(0);" onclick="document.formFb078704.sltNb935705.options[58].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;">
</FONT></A></TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom"><A href="#javascript:void(0);" onclick="document.formFb078704.sltNb935705.options[59].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;">
</FONT></A></TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom"><A href="#javascript:void(0);" onclick="document.formFb078704.sltNb935705.options[60].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;">
</FONT></A></TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom"><A href="#javascript:void(0);" onclick="document.formFb078704.sltNb935705.options[61].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;">
</FONT></A></TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom"><A href="#javascript:void(0);" onclick="document.formFb078704.sltNb935705.options[62].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;">
</FONT></A></TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom"><A href="#javascript:void(0);" onclick="document.formFb078704.sltNb935705.options[63].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;">
</FONT></A></TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom"><A href="#javascript:void(0);" onclick="document.formFb078704.sltNb935705.options[64].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;">
</FONT></A></TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: left; VERTICAL-ALIGN: bottom"><A href="#javascript:void(0);" onclick="document.formFb078704.sltNb935705.options[65].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;">
</FONT></A></TD></TR><TR><TD align=middle style="BACKGROUND-COLOR: #d4d0c8; BORDER-LEFT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; FONT-SIZE: 10pt" width="2%"><CENTER>9</CENTER></TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: left; VERTICAL-ALIGN: bottom">mydata</FONT></TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #000000 2pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: left; VERTICAL-ALIGN: bottom">R9_56483.2</FONT></TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom"> </TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom"> </TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom"> </TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom"> </TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom"> </TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom"> </TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom"> </TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom"> </TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom"> </TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom"> </TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom"> </TD></TR><TR><TD align=middle style="BACKGROUND-COLOR: #d4d0c8; BORDER-LEFT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; FONT-SIZE: 10pt" width="2%"><CENTER>10</CENTER></TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: left; VERTICAL-ALIGN: bottom">data</FONT></TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #000000 2pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: left; VERTICAL-ALIGN: bottom">c111_34567.88</FONT></TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom"> </TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom"> </TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom"> </TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom"> </TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom"> </TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom"> </TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom"> </TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom"> </TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom"> </TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom"> </TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom"> </TD></TR><TR><TD align=middle style="BACKGROUND-COLOR: #d4d0c8; BORDER-LEFT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; FONT-SIZE: 10pt" width="2%"><CENTER>11</CENTER></TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: left; VERTICAL-ALIGN: bottom">data</FONT></TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #000000 2pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: left; VERTICAL-ALIGN: bottom">c112_5645.326</FONT></TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5p

 

[NBVC]

Ok..I think I got what you want.

Now, to explain my previous post exhibit:

First I had to extract the info you wanted from your Sheet2 (in your first post) to for easier matching and combining.

Formula in A1:
=IF(ISERROR(FIND("_",Sheet2!$A1)),Sheet2!$A1,LEFT(Sheet2!$A1,FIND("_",Sheet2!$A1)-1))

Formula in B1:
=IF(ISERROR(FIND("_",Sheet2!$A1)),Sheet2!$A1,LEFT(Sheet2!$A1,FIND("_",Sheet2!$A1)-1))

Copy these down as far as you wish.

Note: These columns can be hidden.

Formula in D5:
=IF(ROW(INDIRECT("A"&COLUMN(B2)))-ROW($A$1)>COUNTIF($A$1:$A$100,$C4),"",INDEX($B$1:$B$100,SMALL(IF($A$1:$A$100=$C4,ROW($A$1:$A$100)),ROW(INDIRECT("A"&COLUMN(B2)))-ROW($A$1))))

Must be confirmed with CTRL+SHIFT+ENTER, not just ENTER.

Then you can copy it across as far as you wish and down as far as you wish.

I really hope this is what you're after.

Good Luck!

 

[edwinb]

Hi NBVC,

Thanks a lot for getting back to me again. I apprecaite it a lot.

I folow your latest instructions and let you know the outcome.

Thanks again,
Edwin B:


====================
This forum ROCKs!!!!

 

[edwinb]

Hi NBVC,
Quick question. Is there a different formula for B1? The formula listed on B1 is the same as A1.

Thanks,
Edwin B