Closest match for a data set

[dbcooper88]

Hello all. Im looking for the closest match for a data set. Here is the data:



[TABLE="width: 0"]
<tbody>[TR]
[TD]A
[/TD]
[TD]B
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]959.5
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]909
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]858.5
[/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]858.5
[/TD]
[/TR]
[TR]
[TD]5
[/TD]
[TD]858.5
[/TD]
[/TR]
[TR]
[TD]6
[/TD]
[TD]910
[/TD]
[/TR]
[TR]
[TD]7
[/TD]
[TD]758.5
[/TD]
[/TR]
[TR]
[TD]8
[/TD]
[TD]808
[/TD]
[/TR]
[TR]
[TD]9
[/TD]
[TD]808
[/TD]
[/TR]
[TR]
[TD]10
[/TD]
[TD]858.5
[/TD]
[/TR]
[TR]
[TD]11
[/TD]
[TD]909
[/TD]
[/TR]
[TR]
[TD]12
[/TD]
[TD]757.5
[/TD]
[/TR]
</tbody>[/TABLE]


How would you find the three consecutive closest match for the last three B's (858.5,909,757.5)? Answer should be 858.5,910,758 which correspond to A’s 5,6,7. TIA

 

[Legacy 143009]

Hello all. Im looking for the closest match for a data set. Here is the data:



[TABLE="width: 0"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]959.5[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]909[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]858.5[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]858.5[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]858.5[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]910[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]758.5[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]808[/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]808[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]858.5[/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD]909[/TD]
[/TR]
[TR]
[TD]12[/TD]
[TD]757.5[/TD]
[/TR]
</tbody>[/TABLE]


How would you find the three consecutive closest match for the last three B's (858.5,909,757.5)? Answer should be 858.5,910,758 which correspond to A’s 5,6,7. TIA

This is a lot of statics. If I were you, I would go for VBA.

 

[dbcooper88]

This is a lot of statics. If I were you, I would go for VBA.

Yea havent been able to find answer.

 

[Legacy 143009]

Yea havent been able to find answer.

Also It is hard to determine what consecutive to pick.

1. 9
2. 7
3. 4
4. 5
5. 7
6. 8
7. 7
8. 8
9. 6

What should I pick? Why?