Patrick020
New Member
- Joined
- Mar 20, 2018
- Messages
- 15
Hi everyone <o></o>
<o> </o>
I would like to generate a list which calculates the largestshortfalls out of a variety of projects. Shortfall is defined as Revenue minusCost. <o></o>
<o> </o>
I would like the formulas to allow you to select a specificfunction from which to assess their projects (in cell G1 below). The array thereforeneeds to dynamic and change depending on which function you choose in G1 whichis what I am struggling with. <o></o>
<o> </o>
I have put an example below: <o></o>
<o> </o>
Ideally I would like a formula to drag down in F4 and in G4.<o></o>
<o> </o>
<tbody>
</tbody><o> </o>
Hopefully that’s clear but let me know if not! <o></o>
<o> </o>
Thank you<o></o>
Patrick
<o> </o>
I would like to generate a list which calculates the largestshortfalls out of a variety of projects. Shortfall is defined as Revenue minusCost. <o></o>
<o> </o>
I would like the formulas to allow you to select a specificfunction from which to assess their projects (in cell G1 below). The array thereforeneeds to dynamic and change depending on which function you choose in G1 whichis what I am struggling with. <o></o>
<o> </o>
I have put an example below: <o></o>
<o> </o>
Ideally I would like a formula to drag down in F4 and in G4.<o></o>
<o> </o>
A<o></o> | B<o></o> | C<o></o> | D<o></o> | E<o></o> | F<o></o> | G<o></o> | |
1<o></o> | Function<o></o> | Project<o></o> | Cost<o></o> | Revenue <o></o> | Selection: <o></o> | Ops <o></o> | |
2<o></o> | Sales <o></o> | Project 1<o></o> | 50<o></o> | 41<o></o> | <o> </o> | <o> </o> | |
3<o></o> | Sales <o></o> | Project 2<o></o> | 21<o></o> | 5<o></o> | Deficit <o></o> | Project<o></o> | |
4<o></o> | Sales <o></o> | Project 3<o></o> | 6<o></o> | 44<o></o> | -14<o></o> | Option 2 <o></o> | |
5<o></o> | Sales <o></o> | Project 4<o></o> | 66<o></o> | 19<o></o> | -14<o></o> | Option 3<o></o> | |
6<o></o> | Sales <o></o> | Project 5<o></o> | 36<o></o> | 25<o></o> | -4<o></o> | Option 1<o></o> | |
7<o></o> | HR <o></o> | Scheme 1<o></o> | 80<o></o> | 66<o></o> | 9<o></o> | Option 4 <o></o> | |
8<o></o> | HR <o></o> | Scheme 2<o></o> | 69<o></o> | 17<o></o> | <o> </o> | <o> </o> | |
9<o></o> | HR <o></o> | Scheme 3<o></o> | 27<o></o> | 57<o></o> | |||
10<o></o> | Ops<o></o> | Option 1<o></o> | 77<o></o> | 73<o></o> | |||
11<o></o> | Ops<o></o> | Option 2<o></o> | 68<o></o> | 54<o></o> | |||
12<o></o> | Ops<o></o> | Option 3<o></o> | 19<o></o> | 5<o></o> | |||
13<o></o> | Ops<o></o> | Option 4<o></o> | 54<o></o> | 63<o></o> | |||
14<o></o> | Ops<o></o> | Option 5<o></o> | 39<o></o> | 72<o></o> | |||
15<o></o> | Ops<o></o> | Option 6<o></o> | 39<o></o> | 53<o></o> |
Hopefully that’s clear but let me know if not! <o></o>
<o> </o>
Thank you<o></o>
Patrick