montecarlo2012
Well-known Member
- Joined
- Jan 26, 2011
- Messages
- 984
- Office Version
- 2010
- Platform
- Windows
Hi.
What formula is possible to use in order to get the relative position. let me give you some illustration first, Please
in my sheet 1 I have this results, as you can see there are a position bin, meaning, I would like on sheet 2 to get the positions of the color cells, let me show you another images of sheet 2
on sheet1 col D the first yellow cell is according to the position Bin is 1 so that value is on sheet 2 on B2 and the same for the rest
Thanks for reading this.
t<body>
t/<body?
What formula is possible to use in order to get the relative position. let me give you some illustration first, Please
in my sheet 1 I have this results, as you can see there are a position bin, meaning, I would like on sheet 2 to get the positions of the color cells, let me show you another images of sheet 2
on sheet1 col D the first yellow cell is according to the position Bin is 1 so that value is on sheet 2 on B2 and the same for the rest
Thanks for reading this.
t<body>
Position Bin | results | |||
1 | ] | 0.841471 | 0.540302 | 1.557408 |
2 | 0.909297 | -0.41615 | -2.18504 | |
3 | ] | 0.14112 | -0.98999 | -0.14255 |
4 | -0.7568 | -0.65364 | 1.157821 | |
5 | -0.95892 | 0.283662 | -3.38052 | |
6 | -0.27942 | 0.96017 | -0.29101 | |
7 | ] | 0.656987 | 0.753902 | 0.871448 |
8 | 0.989358 | -0.1455 | -6.79971 | |
9 | 0.412118 | -0.91113 | -0.45232 | |
10 | ] | -0.54402 | -0.83907 | 0.648361 |
11 | -0.99999 | 0.004426 | -225.951 | |
12 | ] | -0.53657 | 0.843854 | -0.63586 |
13 | 0.420167 | 0.907447 | 0.463021 | |
14 | 0.990607 | 0.136737 | 7.244607 | |
15 | 0.650288 | -0.75969 | -0.85599 | |