E
EADesktop
I am trying to do the following in Excel and not succeeding - any chanc
of some help.
I have two arrays of date and time. Arrays are different lengths.
want to compare one element of array A to all elements of array B, an
do this for all elements of array A.
Say there are n elements in array A.
A, B, C and D are all arrays
For i = 0 to n-1
C = B - A(i) : create a new array C
C = Abs(C) : convert values of C to absolute value e.g. ABS(-2.5)
2.5
Position = min_pos(C) : find array position of smallest element o
array C
Min_difference = C(position)
D(i) = Min_difference
Next i
Cheer
of some help.
I have two arrays of date and time. Arrays are different lengths.
want to compare one element of array A to all elements of array B, an
do this for all elements of array A.
Say there are n elements in array A.
A, B, C and D are all arrays
For i = 0 to n-1
C = B - A(i) : create a new array C
C = Abs(C) : convert values of C to absolute value e.g. ABS(-2.5)
2.5
Position = min_pos(C) : find array position of smallest element o
array C
Min_difference = C(position)
D(i) = Min_difference
Next i
Cheer