Hi, new here, sorry if my question is not very clear.
I have two columns of data for example:
A
1.25
1.3
1.305
1.307
B
1.15
1.3
1.45
1.6
Column B's numbers are considered the 'n th' term
I need to filter through column A with term 'n' and find the nearest values in A that are above and below n by at least difference of 0.1 but no greater than 0.2
If the difference is less than 0.1 between 'n' and the above/below number is A, then somehow I need to search again but this time 2 terms away from n.
I think there are some functions in VBA which would make my job easier, as I have only done c++ before.
Thanks, I appreciate the help,
Michael
Bookmarks