# Search:

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

1. ## Thread: cut/paste scripting - copy a range then paste to a destination range that matches to row/column address criteria - INDEX/MATCH but cut n paste

by benbulloch
Replies
1
Views
154

### Re: cut/paste scripting - copy a range then paste to a destination range that matches to row/column address criteria - INDEX/MATCH but cut n paste

I figured it out. Not the most elegant solution but it works. The "var col = s.getRange(4,1).getValue();" is just a MATCH function. I'd still prefer to have the row lookup without hardcoding the...
2. ## Thread: cut/paste scripting - copy a range then paste to a destination range that matches to row/column address criteria - INDEX/MATCH but cut n paste

by benbulloch
Replies
1
Views
154

### cut/paste scripting - copy a range then paste to a destination range that matches to row/column address criteria - INDEX/MATCH but cut n paste

I'm struggling with some simple copy/paste scripting in Excel/Sheets. I'm a complete scripting newbie. Advanced at Excel/Sheets.
I have a "Today" data entry sheet. I have a "Program" sheet that...
3. ## Thread: Cost Distribution based on Bell Shaped Curve

by benbulloch
Replies
7
Views
39,956

### Re: Cost Distribution based on Bell Shaped Curve

I've been screwing around with the exact question for quite some time and finally have a good normally-distributed s-curve generation formula for spreading project costs over a number of months. ...
4. ## Thread: S Curve dilemma

by benbulloch
Replies
17
Views
37,481

### Re: S Curve dilemma

I've been screwing around with the exact question for quite some time and have a good normally-distributed s-curve generation formula for spreading project costs over a number of months. My question...
5. ## Thread: Financial Statement Modeling - Managing Circular References Using Iteration

by benbulloch
Replies
2
Views
2,162

### Re: Financial Statement Modeling - Managing Circular References Using Iteration

What do you define as "blowing up"? Does the model give you #VALUE errors? These are typical in my models with iteration that blow up. Files-> Options-> Formulas gives the the option of setting...
6. ## Thread: non-normal (skewed) project cost distribution across months - gamma distribution? calculus?

by benbulloch
Replies
5
Views
7,766

### non-normal (skewed) project cost distribution across months - gamma distribution? calculus?

I have a real estate development project with hundreds of cost line items. One cost line is appended below.

I want to distribute the cost for each item across time in a number of distribution...
7. ## Thread: output 1st, 2nd, 3rd ... non-zero value in a column

by benbulloch
Replies
14
Views
2,102

### Re: output 1st, 2nd, 3rd ... non-zero value in a column (or row)

I realized that I could just use:
{=INDEX(D\$127:D\$184,SMALL(IF(D\$128:D\$184>0,ROW(D\$128:D\$184)-ROW(D\$126)),ROWS(A\$1:A1)),1)} (without the + row offset)

With your original formulas, I was picking...
8. ## Thread: output 1st, 2nd, 3rd ... non-zero value in a column

by benbulloch
Replies
14
Views
2,102

### Re: output 1st, 2nd, 3rd ... non-zero value in a column

Most excellent Adam! I knew I was getting close. I had to tweak very slightly to:

{=INDEX(D\$127:D\$184,SMALL(IF(D\$128:D\$184>0,ROW(D\$128:D\$184)-ROW(D\$128)+2),ROWS(A\$1:A1)),1)}

and ...
9. ## Thread: output 1st, 2nd, 3rd ... non-zero value in a column

by benbulloch
Replies
14
Views
2,102

### output 1st, 2nd, 3rd ... non-zero value in a column

I am having difficulty outputting only the non-zero values (computed from a formula) from a column buried towards the bottom of a sheet. I can make an array formula work if the values are in f1:f100...
Results 1 to 9 of 9