maybe by another more simple way
 

thank you, sirs,


for my short myORIGINALLIST table,
Maybe i need to make another shorter myNEWLIST to help me shorten the gap of
my problem.
------------------
imaginary base data {7 index numbers} = {1 to 7's ; €¦..}

something like this

{1,2,3,4,5,6,7}={1,2,3,4,5,6,7 ; 8,9,10,11,12,13,14 ;
etc€¦.} etc€¦.successive multiple of 7 in series

myORIGINAL LIST [Col_A is the index] [Col_B is the data value]
2 2
6 6
8 7
4 11
6 13
6 20
1 22
2 30
4 32

myNEWList builder including 2 minor Conditions only.
(example)
Condition no.1 :To insert another integer if search index = 1
Condition no.2 :To insert another integer if it is b/w orig data value.

myNEW LIST : by a Formula to fill-in this ONE column only.
2
6
7
8<<<<<insert 8 here if index value = 1 [cond. 1]
11
12<<<<<auto-insert here because 12 is exactly b/w 11,13 [cond.2]
13
20
21<<<<<auto-insert here because 21 is exactly b/w 20,22 [cond.2]
22
29<<<<<insert 29 here if index value = 1 [cond. 1]
30
32<<<<<end here my last data
all data are positive integer. from 1 to wherever.

i hope its easy to build the list in my workbook.
anyone please try at least for one shot..thanks

maybe by another more simple way
 

typos again,
sorry, please don't bother the data

here below is the correct one

Maybe by this way can be possible

imaginary base data {7 index numbers} = {1 to 7's ; €¦..}
{1,2,3,4,5,6,7}={1,2,3,4,5,6,7 ; 8,9,10,11,12,13,14 ; etc€¦.}
etc€¦.successive multiple of 7 in series
myORIGINAL LIST [Col_A is the index] [Col_B is the data value]
2 2
6 6
7 7 <<<<<corrected here
4 11
6 13
6 20
1 22
2 30
4 32

List builder including 2 minor Conditions only.
(example)
Condition no.1 insert a value search index = 1
Condition no.2 insert another integer if it is b/w orig data value.

myNEW LIST : by a Formula fill-in this ONE column only.
2
6
7
8 <<<<<insert 8 here if index value = 1 [cond. 1]
11
12 <<<<<auto-insert here because 12 is exactly b/w 11,13 [cond.2]
13
15 <<<<<corrected insert 15 here if index value = 1 [cond. 1]
20
21 <<<<<auto-insert here because 21 is exactly b/w 20,22 [cond.2]
22
29 <<<<<insert 29 here if index value = 1 [cond. 1]
30
32 <<<<<end here

thanks again

"been dribbled to 2007" wrote:

thank you, sirs,

maybe by another more simple way
 

please never mind this post, its finish already.


"been dribbled to 2007" wrote:

typos again,
sorry, please don't bother the data

here below is the correct one

Maybe by this way can be possible

imaginary base data {7 index numbers} = {1 to 7's ; €¦..}
{1,2,3,4,5,6,7}={1,2,3,4,5,6,7 ; 8,9,10,11,12,13,14 ; etc€¦.}
etc€¦.successive multiple of 7 in series
myORIGINAL LIST [Col_A is the index] [Col_B is the data value]
2 2
6 6
7 7 <<<<<corrected here
4 11
6 13
6 20
1 22
2 30
4 32

List builder including 2 minor Conditions only.
(example)
Condition no.1 insert a value search index = 1
Condition no.2 insert another integer if it is b/w orig data value.

myNEW LIST : by a Formula fill-in this ONE column only.
2
6
7
8 <<<<<insert 8 here if index value = 1 [cond. 1]
11
12 <<<<<auto-insert here because 12 is exactly b/w 11,13 [cond.2]
13
15 <<<<<corrected insert 15 here if index value = 1 [cond. 1]
20
21 <<<<<auto-insert here because 21 is exactly b/w 20,22 [cond.2]
22
29 <<<<<insert 29 here if index value = 1 [cond. 1]
30
32 <<<<<end here

thanks again

"been dribbled to 2007" wrote:

thank you, sirs,