Search:

Type: Posts; User: timbledum; Keyword(s):

1. Thread: Modeloff Round 2 Case Study Time is Money

by timbledum
Replies
3
Views
37,455

Re: Modeloff Round 2 Case Study Time is Money

Hi all

Thanks for your appreciation for this, good to see that people are getting value for this, especially with MO coming up in a few weeks!

by timbledum
Replies
4
Views
29,061

Re: Stepping Up, Q4

You are right: =+F74+F78-F84 is the required change in these rows. Of course the results of this question do depend on the answers to the previous questions as well as potentially subsequent...

by timbledum
Replies
4
Views
29,061

Re: Stepping Up, Q4

Hey bud!

An error is in line 87 - that's all I'll tell you for now!
4. Thread: SUMIFS with date periods and names as criteria

by timbledum
Replies
2
Views
1,551

Re: SUMIFS with date periods and names as criteria

Hey bud!

I have also solved this with a combo of index/match and sumifs. In the top-left cell I have =SUMIFS(INDEX(\$B\$2:\$J\$4,MATCH(\$A7,\$A\$2:\$A\$4,0),),\$B\$1:\$J\$1,">="&M\$7,\$B\$1:\$J\$1,"<="&M\$8)...
5. Thread: Modeloff Round 2 Case Study Time is Money

by timbledum
Replies
3
Views
37,455

Re: Modeloff Round 2 Case Study Time is Money

Hey bud. I know this is a bit late, but I'll chime in.

You're on the right track, but you need to use cumulative inflation rather than just the annual inflation rate.

I have found this one by...
Results 1 to 5 of 5