a macro for comparing columns; from A to H

[amin maaleki]

with hello and regards two all members and Mr. Excel
i have this table
<table style="border-collapse: collapse; width: 489pt;" border="0" cellpadding="0" cellspacing="0" width="653"><col style="width: 65pt;" width="87"> <col style="width: 51pt;" width="68"> <col style="width: 65pt;" width="87"> <col style="width: 53pt;" width="71"> <col style="width: 71pt;" width="95"> <col style="width: 54pt;" span="2" width="72"> <col style="width: 76pt;" width="101"> <tbody><tr style="height: 14.25pt;" height="19"> <td class="xl63" style="height: 14.25pt; width: 65pt;" height="19" width="87">A</td> <td class="xl63" style="width: 51pt;" width="68">B</td> <td class="xl63" style="width: 65pt;" width="87">C</td> <td class="xl63" style="width: 53pt;" width="71">D</td> <td class="xl63" style="width: 71pt;" width="95">E</td> <td class="xl63" style="width: 54pt;" width="72">F</td> <td class="xl63" style="width: 54pt;" width="72">G</td> <td class="xl63" style="width: 76pt;" width="101">H</td> </tr> <tr style="height: 14.25pt;" height="19"> <td class="xl64" style="height: 14.25pt;" height="19">COUNTRY1</td> <td class="xl64" style="border-left: medium none;">EXPORT$</td> <td class="xl64" style="border-left: medium none;">COUNTRY2</td> <td class="xl64" style="border-left: medium none;">IMPORT$</td> <td class="xl64" style="border-left: medium none;">SAME CODE</td> <td class="xl64" style="border-left: medium none;">EXPORT$</td> <td class="xl64" style="border-left: medium none;">IMPORT$</td> <td class="xl64" style="border-left: medium none;">30% MINOR</td> </tr> <tr style="height: 14.25pt;" height="19"> <td class="xl64" style="border-top: medium none; height: 14.25pt;" height="19">10190</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">117</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">10190</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">294</td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 14.25pt;" height="19"> <td class="xl64" style="border-top: medium none; height: 14.25pt;" height="19">10210</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">74</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">10210</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">138</td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 14.25pt;" height="19"> <td class="xl64" style="border-top: medium none; height: 14.25pt;" height="19">10290</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">16</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">10290</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">29</td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 14.25pt;" height="19"> <td class="xl64" style="border-top: medium none; height: 14.25pt;" height="19">10511</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">27</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">10511</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">11</td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 14.25pt;" height="19"> <td class="xl64" style="border-top: medium none; height: 14.25pt;" height="19">10519</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">127</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">10519</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">70</td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 14.25pt;" height="19"> <td class="xl64" style="border-top: medium none; height: 14.25pt;" height="19">10639</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">127</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">10639</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">47</td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 14.25pt;" height="19"> <td class="xl64" style="border-top: medium none; height: 14.25pt;" height="19">10690</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">19</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">10690</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">47</td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 14.25pt;" height="19"> <td class="xl64" style="border-top: medium none; height: 14.25pt;" height="19">…</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">…</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">…</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">…</td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 14.25pt;" height="19"> <td class="xl64" style="border-top: medium none; height: 14.25pt;" height="19">…</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">…</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">…</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">…</td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 14.25pt;" height="19"> <td class="xl64" style="border-top: medium none; height: 14.25pt;" height="19">…</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">…</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">…</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">…</td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 14.25pt;" height="19"> <td class="xl64" style="border-top: medium none; height: 14.25pt;" height="19">961700</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">19</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">961700</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">18</td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 14.25pt;" height="19"> <td class="xl64" style="border-top: medium none; height: 14.25pt;" height="19">961800</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">558</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">961800</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">1</td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 14.25pt;" height="19"> <td class="xl64" style="border-top: medium none; height: 14.25pt;" height="19">970110</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">970</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">970110</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">27</td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 14.25pt;" height="19"> <td class="xl64" style="border-top: medium none; height: 14.25pt;" height="19">970190</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">116</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">970190</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">3</td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 14.25pt;" height="19"> <td class="xl64" style="border-top: medium none; height: 14.25pt;" height="19">970500</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">0</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">970500</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">3</td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 14.25pt;" height="19"> <td class="xl64" style="border-top: medium none; height: 14.25pt;" height="19">970600</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">0</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">970600</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">91,969</td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> </tr> </tbody></table>
Column A: Country1 Export Code
Column B: Export value for Country 1
Column C: Country2 Import Code
Column D: Import value for Country 2

excel 2003 file
http://www.4shared.com/account/file/101679321/3bef232d/file.html?sId=cQbrAl6Snyxwpbv0
excel 2007 file
http://www.4shared.com/account/file/101679319/1e19f8dc/file.html?sId=cQbrAl6Snyxwpbv0

NOW
i want to fill in Column E to H with a macro
Column E: same code in Column A and Column C
Column F: export value for same code (from Column B)
Column G: import value for same code (from Column D)
Column H: 30 percent of Minor Value
for example if F3 is 9000 and G3 is 1000 then H3 will be 2700 that is 30 percent of F3

thanks a lot for your attention
sincerely
amin

 

[VoG]

Why do you need a macro? Not sure about what you wanted in column H so I guessed. Formulas in row 2 filled down.

<b>Sheet1</b><br /><br /><table border="1" cellspacing="0" cellpadding="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:76px;" /><col style="width:59px;" /><col style="width:76px;" /><col style="width:62px;" /><col style="width:83px;" /><col style="width:63px;" /><col style="width:63px;" /><col style="width:88px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td > </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 style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >1</td><td style="text-align:center; ">COUNTRY1</td><td style="text-align:center; ">EXPORT$</td><td style="text-align:center; ">COUNTRY2</td><td style="text-align:center; ">IMPORT$</td><td style="text-align:center; ">SAME CODE</td><td style="text-align:center; ">EXPORT$</td><td style="text-align:center; ">IMPORT$</td><td style="text-align:center; ">30% MINOR</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >2</td><td style="text-align:center; ">10190</td><td style="text-align:center; ">117</td><td style="text-align:center; ">10190</td><td style="text-align:center; ">294</td><td style="text-align:center; ">10190</td><td style="text-align:center; ">117</td><td style="text-align:center; ">294</td><td style="text-align:center; ">88.2</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >3</td><td style="text-align:center; ">10210</td><td style="text-align:center; ">74</td><td style="text-align:center; ">10210</td><td style="text-align:center; ">138</td><td style="text-align:center; ">10210</td><td style="text-align:center; ">74</td><td style="text-align:center; ">138</td><td style="text-align:center; ">41.4</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >4</td><td style="text-align:center; ">10290</td><td style="text-align:center; ">16</td><td style="text-align:center; ">10290</td><td style="text-align:center; ">29</td><td style="text-align:center; ">10290</td><td style="text-align:center; ">16</td><td style="text-align:center; ">29</td><td style="text-align:center; ">8.7</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >5</td><td style="text-align:center; ">10511</td><td style="text-align:center; ">27</td><td style="text-align:center; ">10511</td><td style="text-align:center; ">11</td><td style="text-align:center; ">10511</td><td style="text-align:center; ">27</td><td style="text-align:center; ">11</td><td style="text-align:center; ">3.3</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >6</td><td style="text-align:center; ">10519</td><td style="text-align:center; ">127</td><td style="text-align:center; ">10519</td><td style="text-align:center; ">70</td><td style="text-align:center; ">10519</td><td style="text-align:center; ">127</td><td style="text-align:center; ">70</td><td style="text-align:center; ">21</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >7</td><td style="text-align:center; ">10639</td><td style="text-align:center; ">127</td><td style="text-align:center; ">10639</td><td style="text-align:center; ">47</td><td style="text-align:center; ">10639</td><td style="text-align:center; ">127</td><td style="text-align:center; ">47</td><td style="text-align:center; ">14.1</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >8</td><td style="text-align:center; ">10690</td><td style="text-align:center; ">19</td><td style="text-align:center; ">10690</td><td style="text-align:center; ">47</td><td style="text-align:center; ">10690</td><td style="text-align:center; ">19</td><td style="text-align:center; ">47</td><td style="text-align:center; ">14.1</td></tr></table><br /><table style="font-family:Arial; font-size:10pt; border-style: groove ;border-color:#00ff00;background-color:#fffcf9; color:#000000; "><tr><td ><b>Spreadsheet Formulas</b></td></tr><tr><td ><table border = "1" cellspacing="0" cellpadding="2" style="font-family:Arial; font-size:9pt;"><tr style="background-color:#cacaca; font-size:10pt;"><td >Cell</td><td >Formula</td></tr><tr><td >E2</td><td >=A2</td></tr><tr><td >F2</td><td >=B2</td></tr><tr><td >G2</td><td >=D2</td></tr><tr><td >H2</td><td >=30%*G2</td></tr></table></td></tr></table> <br />Excel tables to the web - Excel Jeanie Html 4

 

[amin maaleki]

dear Mr. Excel
sorry that i could not explain my mind correctly
number of rows are approximately 120000 and some cells in A and C columns are not same in one rows . this table only shows first rows that this two columns have same codes.

 

[VoG]

some cells in A and C columns are not same in one rows

Can you give some examples of what you mean and what you want the output to be.

 

[amin maaleki]

the correct table is here:
we have duplicate cells within A and C columns and some different codes in each columns with same codes in different rows
thanks a lot

<table style="border-collapse: collapse; width: 489pt;" border="0" cellpadding="0" cellspacing="0" width="653"><col style="width: 65pt;" width="87"> <col style="width: 51pt;" width="68"> <col style="width: 65pt;" width="87"> <col style="width: 53pt;" width="71"> <col style="width: 71pt;" width="95"> <col style="width: 54pt;" span="2" width="72"> <col style="width: 76pt;" width="101"> <tbody><tr style="height: 14.25pt;" height="19"> <td class="xl63" style="height: 14.25pt; width: 65pt;" height="19" width="87">A</td> <td class="xl63" style="width: 51pt;" width="68">B</td> <td class="xl63" style="width: 65pt;" width="87">C</td> <td class="xl63" style="width: 53pt;" width="71">D</td> <td class="xl63" style="width: 71pt;" width="95">E</td> <td class="xl63" style="width: 54pt;" width="72">F</td> <td class="xl63" style="width: 54pt;" width="72">G</td> <td class="xl63" style="width: 76pt;" width="101">H</td> </tr> <tr style="height: 14.25pt;" height="19"> <td class="xl64" style="height: 14.25pt;" height="19">COUNTRY1</td> <td class="xl64" style="border-left: medium none;">EXPORT$</td> <td class="xl64" style="border-left: medium none;">COUNTRY2</td> <td class="xl64" style="border-left: medium none;">IMPORT$</td> <td class="xl64" style="border-left: medium none;">SAME CODE</td> <td class="xl64" style="border-left: medium none;">EXPORT$</td> <td class="xl64" style="border-left: medium none;">IMPORT$</td> <td class="xl64" style="border-left: medium none;">30% MINOR</td> </tr> <tr style="height: 14.25pt;" height="19"> <td class="xl64" style="border-top: medium none; height: 14.25pt;" height="19">10190</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">117</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">10190</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">294</td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 14.25pt;" height="19"> <td class="xl64" style="border-top: medium none; height: 14.25pt;" height="19">10212</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">74</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">10210</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">138</td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 14.25pt;" height="19"> <td class="xl64" style="border-top: medium none; height: 14.25pt;" height="19">10290</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">16</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">10215</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">29</td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 14.25pt;" height="19"> <td class="xl64" style="border-top: medium none; height: 14.25pt;" height="19">10511</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">27</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">10210</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">11</td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 14.25pt;" height="19"> <td class="xl64" style="border-top: medium none; height: 14.25pt;" height="19">10639</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">127</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">10210</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">70</td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 14.25pt;" height="19"> <td class="xl64" style="border-top: medium none; height: 14.25pt;" height="19">10890</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">127</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">10639</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">47</td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 14.25pt;" height="19"> <td class="xl64" style="border-top: medium none; height: 14.25pt;" height="19">11141</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">19</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">10890</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">47</td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 14.25pt;" height="19"> <td class="xl64" style="border-top: medium none; height: 14.25pt;" height="19">…</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">…</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">…</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">…</td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 14.25pt;" height="19"> <td class="xl64" style="border-top: medium none; height: 14.25pt;" height="19">…</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">…</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">…</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">…</td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 14.25pt;" height="19"> <td class="xl64" style="border-top: medium none; height: 14.25pt;" height="19">…</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">…</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">…</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">…</td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 14.25pt;" height="19"> <td class="xl64" style="border-top: medium none; height: 14.25pt;" height="19">961800</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">19</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">961700</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">18</td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 14.25pt;" height="19"> <td class="xl64" style="border-top: medium none; height: 14.25pt;" height="19">970110</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">558</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">961800</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">1</td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 14.25pt;" height="19"> <td class="xl64" style="border-top: medium none; height: 14.25pt;" height="19">986730</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">970</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">970110</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">27</td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 14.25pt;" height="19"> <td class="xl64" style="border-top: medium none; height: 14.25pt;" height="19">986730</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">116</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">970190</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">3</td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 14.25pt;" height="19"> <td class="xl64" style="border-top: medium none; height: 14.25pt;" height="19">995040</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">0</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">970500</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">3</td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 14.25pt;" height="19"> <td class="xl64" style="border-top: medium none; height: 14.25pt;" height="19">995040</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">0</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">970600</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">91,969</td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> </tr> </tbody></table>

 

[VoG]

So what should happen if (a) A and C are the same (b) A and C are different?

 

[amin maaleki]

Dear Mr.Excel
You are right in computing H column
it is 30 percent of major value. in row two 294>117 and H2 is 30 percent of 294

sincerely yours
amin

 

[amin maaleki]

i do not want to comparing A and c columns in same rows. i want to
1- comparing this A and C columns,
2- extracting same codes in column E
3- fill F and G columns with B and D values of Joint A and C codes
4- computing 30 percent of major value in B and D in column H


sincerely
amin

 

[amin maaleki]

can anyone solve my problem?

 

[Legacy 68668]

i do not want to comparing A and c columns in same rows. i want to
1- comparing this A and C columns,
2- extracting same codes in column E
3- fill F and G columns with B and D values of Joint A and C codes
4- computing 30 percent of major value in B and D in column H

sincerely
amin

Your explanation does not make us understand what you are trying to do.

same code with what ?
what is Joint A and C codes ?

Seeing your desired results out of your sample posted will help.