Switch from attached excel sheet to two matrices = one pair and one odd
We have in the example a planilia that uses from 01 to 50, I need to change
* Only pairs =
02 04 06 08 10 12
14 16 18 20 22 24
26 28 30 32 34 36
38 40 42 44 46 48
50 52 54 56 58 60
62 64 66 68 70 72
74 76 78 80 82 84
86 88 90 92 94 96
98 00
And another odd
01 03 05 07 09 11
13 15 17 19 21 23
25 27 29 31 33 35
37 39 41 43 45 47
49 51 53 55 57 59
61 63 65 67 69 71
73 75 77 79 81 83
85 87 89 91 93 95
97 99
So you have to create two excel sheets, just swap the tem in the example
https://www.excelforum.com/attachmen...1&d=1511373989
Bookmarks