Closest match for a data set

[dbcooper88]

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

A	B
1	959.5
2	909
3	858.5
4	858.5
5	858.5
6	910
7	758.5
8	808
9	808
10	858.5
11	909
12	757.5

<tbody>
</tbody>

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:

A	B
1	959.5
2	909
3	858.5
4	858.5
5	858.5
6	910
7	758.5
8	808
9	808
10	858.5
11	909
12	757.5

<tbody>
</tbody>

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?