detect the upper (+1) and lower (-1) adjacent of the draw line reference.

detect the upper (+1) and lower (-1) adjacent of the draw line reference
25 being the last ad and i is 01 and vice versa,
https://www.excelforum.com/attachmen...1&d=1566389220

Perhaps you'll need to explain a bit more. I do NOT follow you. Are you just adding +1 for upper; and subtracting -1 from lower? Need better example WITH results

ok thanks for viewing the post
so if in the 1st position of the draw line was the number 02 its adjacent are 01x 03
(x) = 02

I'm still not certain I know what you are looking for...but let me know how this works?

Hello, queue, we have a problem, almost there, is missing a position?
* must have 15 equal positions of the draw, sorry if in the example I didn't see, the rest is correct

Go to column AE, insert new column there (it will move other cells to the right). Then copy AD7: AD1838 and Paste in Column AE.
Click the Add Reputation if this has helped you in any part/ any way. Bueno suerte!

ok thank you queusef