D
dsal
Hey guys, great site here and very helpful
I have an issue here with data that needs to be used, here goes.
A ______ B _______ f(A) ______ f(B)
1.1 _____ 1.0 _____ value _____ value
1.8 _____ 2.5 _____ value _____ value
2.5 _____ 2.7 _____ value _____ value
3.2 _____ 3.6 _____ value _____ value
3.7 _____ _ _ _____ value
The above is a representation of what is going on. I have 4 columns.
A and B represent a location in space, and f(A) and f(B) are data
values at these respective locations.
I need to take the difference between f(A) and f(B), but to do that, I
must first match up as close as possible columns A and B. For example,
in the above set I would want to match up...
1.1 with 1.0
1.8 would be deleted, as well as the f(A) value corresponding to it
2.5 with 2.5
3.2 with 2.7
3.7 with 3.6
This example would be easy to do manually, except in reality the
columns do not match up this nicely, and A and B are about 100 and 80
cells long respectively.
My thoughts on solving this would be to write a code that would take
the difference between columns A and B, and to use the two cells with
the -smallest- difference between them, and the corresponding values of
f(A) and f(B) to achieve the goal. The end result must be columns of
equal lengths, so some cells need to be deleted.
I hope I have explained this problem well. Please ask questions if
something needs clearing up.
Thanks alot,
-Dan
I have an issue here with data that needs to be used, here goes.
A ______ B _______ f(A) ______ f(B)
1.1 _____ 1.0 _____ value _____ value
1.8 _____ 2.5 _____ value _____ value
2.5 _____ 2.7 _____ value _____ value
3.2 _____ 3.6 _____ value _____ value
3.7 _____ _ _ _____ value
The above is a representation of what is going on. I have 4 columns.
A and B represent a location in space, and f(A) and f(B) are data
values at these respective locations.
I need to take the difference between f(A) and f(B), but to do that, I
must first match up as close as possible columns A and B. For example,
in the above set I would want to match up...
1.1 with 1.0
1.8 would be deleted, as well as the f(A) value corresponding to it
2.5 with 2.5
3.2 with 2.7
3.7 with 3.6
This example would be easy to do manually, except in reality the
columns do not match up this nicely, and A and B are about 100 and 80
cells long respectively.
My thoughts on solving this would be to write a code that would take
the difference between columns A and B, and to use the two cells with
the -smallest- difference between them, and the corresponding values of
f(A) and f(B) to achieve the goal. The end result must be columns of
equal lengths, so some cells need to be deleted.
I hope I have explained this problem well. Please ask questions if
something needs clearing up.
Thanks alot,
-Dan