I have data tables like this example, nine entries at A1:B9 in this case: A B -- --- 1 2.9 2 5. Sengoku Musou 3 Moushouden Wii Iso. 06 3 7 4 8.84 5 10.87 6 13.24 7 16.22 8 20.25 9 36.7 The above represents nine measurements of a non linear increasing physical variable in B, Voltage for example, and A represents exactly each one of nine round minutes the measurement was done. I want to create a second table, columns E and F, with a quantity of rows that is the 'next integer' for the highest value in the B column. Samsung Programs Download.

In this case, B9=36.7, thus it will have 37 rows. Column F1:F37 will contain integers 1 to 37, column E must have numeric values that correspond to F, in the same relationship as between columns A to B. In other words, interpolate the column E values corresponding to the column F values.

For example, A3=3 and B3=7. Kladionica Brazil Lista. In this case, F7=7 and E7=3 because B already included the integer 7 and has a matching value in column A. However, F8=8, which is an intermediate value not contained in column B.