Hi,
I have two data row, Index 1 and Index 2.
Index 1 Index 2
12.5 14.4
12.5 14.4
10.3 14.4
11.9 14.4
12.5 14.4
16.4 14.4
12.5 14.4
12.5 11
12.5 14.4
12 14.4
12 13
12.5 11.2
10.3 14.4
11.9 14.4
12.5 14.4
16.4 14.4
12.5 11
12.5 14.4
12.5 14.4
11.7 13
I have to make the third column which contains value which is interpolated from the table.
Index 2
Index 1 6 7 8 9 10 11 12 13 14 15
11 628 637 654 677 711 752 794 836 879 921
12 928 941 966 1000 1050 1112 1173 1235 1298 1360
13 1312 1330 1365 1412 1484 1570 1657 1745 1833 1921
14 1790 1814 1861 1925 2023 2141 2258 2378 2499 2618
15 2372 2403 2465 2550 2679 2835 2990 3149 3309 3467
16 3035 3087 3184 3312 3490 3701 3912 4130 4372 4587
17 3849 3928 4079 4273 4503 4741 5012 5310 5671 5998
18 4858 4989 5221 5515 5834 6134 6525 6979 7571 8089
19 6118 6342 6700 7142 7611 8052 8652 9359 1031111106
Excel sheet is attached. Please help
Bookmarks