comparing columns with a macro

[amin maaleki]

With Special Thanks to Mr. Excel and All members
i correct my last past

i have this table with approximately 120000 rows:

A B C D E F G H
COUNTRY1 EXPORT$ COUNTRY2 IMPORT$ SAME CODE EXPORT$ IMPORT$ 30% MINOR
10190 117 10190 294
10212 74 10210 138
10290 16 10215 29
10511 27 10210 11
10639 127 10210 70
10890 127 10639 47
11141 19 10890 47
… … … …
… … … …
… … … …
961800 19 961700 18
970110 558 961800 1
986730 970 970110 27
986730 116 970190 3
995040 0 970500 3
995040 0 970600 91,969

this table has duplicate cells within A and C columns and some codes are different between A and C (some codes are in A that is not in C and viceversa)
i want to:
1- comparing this A and C columns,
2- extracting same codes of A and C in column E
3- fill F and G columns with B and D values of Joint A and C codes
4- computing x (for example 30) percent of major value in B and D in column H


sincerely
amin

 

[venkat1926]

best way is create a macro doing those steps and edit the macro

 

[Legacy 68668]

Duplicate

a macro for comparing columns; from A to H