Dear all,
I have managed to successfully use a do until loop, however once finished, I would like it to move to the next row and do the same thing.
Appreciate any guidance.
Thanks,
Themd
Please Login or Register to view this content.
Dear all,
I have managed to successfully use a do until loop, however once finished, I would like it to move to the next row and do the same thing.
Appreciate any guidance.
Thanks,
Themd
Please Login or Register to view this content.
Last edited by Themd; 07-20-2009 at 07:36 AM. Reason: making it user friendly and in line with forum rules.
Welcome to the forum, Themd.
Please take a few minutes to read the forum rules, and then edit your post to add code tags.
Thanks.
Entia non sunt multiplicanda sine necessitate
Thank you.
Can you post a sanitized workbook that shows what you're trying to do?
I have a dataset for each Name by rows. However the data is in intervals of three. It has been collected every three months. What I would like to do is to interpolate the cells between two periods for the whole row. I have done it for one row, but I think I need an addition to the formula to make it go to the next row and repeat the same thing.
Example is attached.
Thanks,
Themd
Try this:
Please Login or Register to view this content.
Last edited by shg; 07-17-2009 at 03:31 PM.
This is great thank you.
However, this is taking the first number and the last number and interpolating. My coding would do it between each number separately.
when you have. 1 5 5 7 2 4
I would like to be able to interpolate between 1 and 5, 5 and 5 so on...
is it possible to combine my coding with yours?
Thanks.
Themd
Oops -- omitted Trend:
Please Login or Register to view this content.
Sorry,
I got it. I was being a little bit lazy
Thanks for all your help,
Themd
You're welcome. Would you please mark the thread as Solved?
Thanks. I'll do.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks