15 positions formatiosn( e ) ( 0)

jack

Member
exemplo= tip map karnauth
Row\Col
A
B
1
eeeeeeeeeeeeeee A1: =SUBSTITUTE(SUBSTITUTE(DEC2BIN(INT((ROW(A1) - 1)/256),7) & DEC2BIN(MOD(ROW(A1) - 1,256),8), 0, "e"), 1, 0)
2
eeeeeeeeeeeeee0
3
eeeeeeeeeeeee0e
4
eeeeeeeeeeeee00
5
eeeeeeeeeeee0ee
6
eeeeeeeeeeee0e0
7
eeeeeeeeeeee00e
8
eeeeeeeeeeee000
9
eeeeeeeeeee0eee
10
eeeeeeeeeee0ee0
11
eeeeeeeeeee0e0e
12
eeeeeeeeeee0e00
13
eeeeeeeeeee00ee
14
eeeeeeeeeee00e0
 

jack

Member
is corret? please
15 positions
=DEC2BIN(INT(ROW(A1)/256),7) & DEC2BIN(MOD(ROW(A1),256),8)

You might wrap that in a SUBSTITUTE(...,"1","e") if you prefer
 

jack

Member
almost there just that 15 is the total of the letter is and 0
* Must be all goes much over 15, 15 here means the amount on line
* Nothing to do with the total, should give much more
example
* E00eee0000ee0eee 15 is the total number and not possible
Another example = ooeeeeoooeeeeoo up
Of 0000000000000000 until 111111111111111111
 

Sidebar

Top