R
Richard G
Have a list of numbers in a table. Has a lot of gaps.
Need to fill the gaps, but only between certain numbers.
For example I have the following numbers in my table:
1,2,5,9,16,35,75(actually i have a lot more but this is an
example). What I need to do is fill in the gaps if the
difference between the first number and the next number is
less than 10 different numbers. So since 2 and 5 have
less than 10 different numbers between them, then it would
fill in 3,4 and 5 and 9 would fill in 6,7,8 and 9 and 16
would fill in 10,11,12,13,14,15 but 16 and 35 would fill
in nothing because it is more than 10 numbers apart?? HELP!
..
Need to fill the gaps, but only between certain numbers.
For example I have the following numbers in my table:
1,2,5,9,16,35,75(actually i have a lot more but this is an
example). What I need to do is fill in the gaps if the
difference between the first number and the next number is
less than 10 different numbers. So since 2 and 5 have
less than 10 different numbers between them, then it would
fill in 3,4 and 5 and 9 would fill in 6,7,8 and 9 and 16
would fill in 10,11,12,13,14,15 but 16 and 35 would fill
in nothing because it is more than 10 numbers apart?? HELP!
..