How to write a formula?

Question

excel

Tell me how to write a formula for bk that will look for points that fall into the area of ​​\u200b\u200bthe point being checked, i.e. for point 2, these are points 4, 6, 9; for 1 - 0, for 4 - 0, for 6 - 0, for 9 - 0, for 10 - 9, for 8 - 6, 9, 10, for 7 - 6, 8, 9, 10, for 5 - 1, 4, 6, 9, 10, for 3 - 1, 4, 6?

Answer 1

Because Your output is quite specific - it is best to implement the task using a self-written formula in VBA. An hour or two for a specialist to write a function.