actually i am trying to fill the missing values (my last post) in the forum. If the last 5 values are missing for any indiviual , i have to fill them. the formula to fill these values is given in column E49 and so on . as i have 65 variables and 84 indiviulas . so i will have to do a lot editing. to aviod tthis i am using the formula in column D see cell D49. but the issue with this formula is that it is using relative cell addressing.
((End Value/Start Value)^(1/(Periods - 1)) -1) must be fixed
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.