generate only initial and final suits using lasts digits even / odd.

generate only initial and final suits
using lasts digits even / odd
generate the crack or suits, but only initial and final
* of the two par / odd patterns = 0,2,4,68 and 1,3,5,7,9
suits in the central band is not used, only
* the 1st suits of each pattern, and the last
* The goal is to separate the suits from both ends.
* of the 25/15 draw line
* doubts?
https://www.excelforum.com/attachmen...1&d=1559734010

All as array fomulas with shift control enter
q6
=INDEX($A6:$O6,SMALL(IF(MOD($A6:$O6,2)=0,COLUMN($A6:$O6),""),COLUMN(A1)))

U6
=INDEX($A6:$O6,SMALL(IF(MOD($A6:$O6,2)=1,COLUMN($A6:$O6),""),COLUMN(A1)))

z6
=INDEX($A6:$O6,LARGE(IF(MOD($A6:$O6,2)=0,COLUMN($A6:$O6),""),4-COLUMN(A1)))

ad6
=INDEX($A6:$O6,LARGE(IF(MOD($A6:$O6,2)=1,COLUMN($A6:$O6),""),4-COLUMN(A1)))

All formulas can be copied to the other 2 cells to the right

please, davsat, you get by on the download sheet. please

hello,DAVSTH okay now you can do for these new patterns, bass
/ high using the same formulas only changes from odd / even down / high
low = 0.1,2,3,4
high = 5,6,7,8,9
change, down / high please!!!!

it is not clear what you are asking, why not provide the expected results in an attached sheet like before?

hello,davsth thanks for watching the post,
* in the previous formulas was used
* par = 0.2,4,6,8
odd = 1,3,5,7,9
now you have to use the same formulas
* but only changes the parameters
* high = 5,6,7,8,9
low = 0.1,2,3,4
just change the patterns even / odd to = low / high
* please
* because I will use the two types of patterns
* you use the same formulas, but change the param- eters down / high now

Which part has doubts?

hello, you have to change the parameter
for = 0,2,4,6,8 and odd = 1,3,5,7,9
change down = 0.1,2,3,4 and high = 5,6,7,8,9

ok,yes,JETEMC corret, conglatulations, thank you!!!