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