|
1 |
2 |
3 |
4 |
5 |
6 |
7 |
8 |
9 |
10 |
11 |
12 |
A |
0.038 |
0.011 |
0.002 |
0.08 |
0.033 |
0.002 |
0.002 |
0.035 |
0.7 |
0.05 |
0.033 |
0.008 |
B |
0.342 |
0.474 |
0.103 |
0.1 |
0.343 |
0.103 |
0.103 |
0.51 |
0.56 |
0.1 |
0.343 |
0.05 |
C |
4.21 |
0.02 |
0.99 |
1 |
5.1 |
0.99 |
0.99 |
0.96 |
1.1 |
1.1 |
1.1 |
1.1 |
D |
|
|
|
|
|
|
|
|
|
|
|
|
E |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
I have this from 1 to 1550 so L6 is just a ref cell when I click a button it looks up the row number and displays the column a1.b1.c1.d1.e1 and displays the respective results. |
Now I have done this using a shortcut cntrl M to go up and cntrl N to go down. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
The problem is I have five other cells which vary the results of lets say A1 to E1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
rtw |
1 |
|
|
|
|
|
|
|
|
|
|
|
going |
2 |
|
|
|
|
|
|
|
|
|
|
|
variance |
2 |
|
|
|
|
|
|
|
|
|
|
|
ado |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
so by adjusting RTW from 1 to 2 the cells at A1 coloured red will change to lets say from .038 to .022 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
so I go through 1500 results then change cell RTW to 2 and have to start again from 1 to 1500; as RTW goes up to eight that makes 12000 clicks or cntrl n till it get to 1500 then change RTW to 2 then cntrl m back to 1 if you see what I mean. |
In real terms as the other cells go up to 5 that's just over 1 million results I started at 12:45 and have just finished one sheet, so that is 5 hours lol |
|
|
|
|
|
|
|
|
|
|
|
|
|
Theoretically I can do it with just 5 cells and make cell A1 start at .001 have cells b c d e at zero and when A1 reaches 10 then b1 becomes .001 it reaches 10 again and cell b1 becomes .0002 etc but that's still 10,000 just to make cells a1 and b1 reach 10 in divisions of .001 again that way is 10 million variances. |
|
|
|
|
|
|
|
|
|
|
|
|
|
There must be a way?
Anybody fancy giving me a quick tutorial on how to start! |
|
|
|
|
|
|
|
|
|
|