Another Problem
Another Problem
(OP)
Can someone show me how to 'skip' cells to provide data every 'n'th year, in the sheet attached, I've used 3 years as 'n', but, it could be 5 or 10 or whatever. incrementing each year from a fixed amount to an uniform increase.
Dik
Dik





RE: Another Problem
Dik
RE: Another Problem
RE: Another Problem
Cheers
Greg Locock
New here? Try reading these, they might help FAQ731-376: Eng-Tips.com Forum Policies http://eng-tips.com/market.cfm?
RE: Another Problem
Thanks, Dik
RE: Another Problem
Better is to learn what the OFFSET function can do for you.
"People will work for you with blood and sweat and tears if they work for what they believe in......" - Simon Sinek
RE: Another Problem
CODE
RE: Another Problem
Fwiw, I like the elegance of BigInch's solution.
Easier to build, understand, maintain, and gather the output (for example lookup)
=====================================
(2B)+(2B)' ?
RE: Another Problem
"People will work for you with blood and sweat and tears if they work for what they believe in......" - Simon Sinek
RE: Another Problem
Dik
RE: Another Problem
"People will work for you with blood and sweat and tears if they work for what they believe in......" - Simon Sinek
RE: Another Problem
If you needed a professional nutcracker that cost 1000 today, but the cost increased by 10 each year, but you only needed the services each three or four years... the final example accommodates that... and I can copy the lines easily... You can easily change the info in case the nutcracker was 1500 today and increased 20 each year but you only needed the services every six years.
Your OFFSET function approach to data is an excellent one, and I will use it... thanks...
Dik
RE: Another Problem
In fact I believe mine works for any "skip year" value >= 0
Are you using Excel?
"People will work for you with blood and sweat and tears if they work for what they believe in......" - Simon Sinek
RE: Another Problem
I posted the final method for others to gain from this brief 'learning excursion'...
Dik
RE: Another Problem
No offense taken at all. Totally cool.
"People will work for you with blood and sweat and tears if they work for what they believe in......" - Simon Sinek