Match numerical data using excel VBA
 

hello everyone

I am new to excel vba and trying hard to solve a problem a part of
which i m mentioning in this post .

actually i hav two set of datas 1] approx 1000 values 2] 2500 values

i hav to find match each value for data set 1 from data set 2
these are the values of data set 1

738657.340 1949567.280 -15.210
738656.150 1949568.930 -15.150
738654.710 1949570.560 -15.120
738652.650 1949572.890 -15.110
738651.420 1949574.790 -15.040
738649.810 1949576.760 -15.030
738647.330 1949579.630 -15.000

so wat i hav planned to do this is to first find "nearest not exact
match" for first value (738657.340) which vary only of +3 or -3 of
this value and if this condition satisfied then corresponding value to
next column ( 194567.280 ) which shud also vary only +3 or -3

both conditions should satisfy

for Example
my data1 in a1 nd b1 and program has found match in e7 then f7-b1
shuld also <=3 or =3 be of b1 and like wise for rest of data

sum match i srchd manually like this
738657.340 1949567.280 -15.210
738656.830 1949567.980 -15.340
738653.480 1949571.230 -15.270
738651.470 1949573.080 -15.310
738648.890 1949576.060 -15.260
738647.320 1949577.520 -15.250


738656.150 1949568.930 -15.150
738654.710 1949570.560 -15.120
738652.650 1949572.890 -15.110
738651.420 1949574.790 -15.040
738649.810 1949576.760 -15.032

I HOP N WISH I WIL GET SUPPORT FROM THIS FORUM ...SUGGESTIONS PLZ

MANY THANX

Match numerical data using excel VBA
 

i hope somebody will help you, but i think it would be helpful if you wrote in
english instead of instant messenger.

--


Gary


wrote in message
oups.com...
hello everyone

I am new to excel vba and trying hard to solve a problem a part of
which i m mentioning in this post .

actually i hav two set of datas 1] approx 1000 values 2] 2500 values

i hav to find match each value for data set 1 from data set 2
these are the values of data set 1

738657.340 1949567.280 -15.210
738656.150 1949568.930 -15.150
738654.710 1949570.560 -15.120
738652.650 1949572.890 -15.110
738651.420 1949574.790 -15.040
738649.810 1949576.760 -15.030
738647.330 1949579.630 -15.000

so wat i hav planned to do this is to first find "nearest not exact
match" for first value (738657.340) which vary only of +3 or -3 of
this value and if this condition satisfied then corresponding value to
next column ( 194567.280 ) which shud also vary only +3 or -3

both conditions should satisfy

for Example
my data1 in a1 nd b1 and program has found match in e7 then f7-b1
shuld also <=3 or =3 be of b1 and like wise for rest of data

sum match i srchd manually like this
738657.340 1949567.280 -15.210
738656.830 1949567.980 -15.340
738653.480 1949571.230 -15.270
738651.470 1949573.080 -15.310
738648.890 1949576.060 -15.260
738647.320 1949577.520 -15.250


738656.150 1949568.930 -15.150
738654.710 1949570.560 -15.120
738652.650 1949572.890 -15.110
738651.420 1949574.790 -15.040
738649.810 1949576.760 -15.032

I HOP N WISH I WIL GET SUPPORT FROM THIS FORUM ...SUGGESTIONS PLZ

MANY THANX