blackorchids2002
Board Regular
- Joined
- Dec 29, 2011
- Messages
- 138
Hi Masters,
I badly need help on how to use match to pair data within the same column. I would need a formula to pair the data. Below is the table to explain further.
I have columns A to G. I want to pair the weight in column B, then column C and so on and so forth.
For you to pair the data, let say in column F, I could pair 2.100 to 2.130 or I could also pair 2.100 to 1.800. I want to come up in paring within the range of +0.030 and -0.030.
Another example on the same column F, I can pair 2.115 and 2.130. I cannot pair 2.115 and 2.170 because it is not within the weight interval of +-0.030.
I needed help on how to formulate the formula.
<tbody>
</tbody>
Cheers,
blackorchids2002
I badly need help on how to use match to pair data within the same column. I would need a formula to pair the data. Below is the table to explain further.
I have columns A to G. I want to pair the weight in column B, then column C and so on and so forth.
For you to pair the data, let say in column F, I could pair 2.100 to 2.130 or I could also pair 2.100 to 1.800. I want to come up in paring within the range of +0.030 and -0.030.
Another example on the same column F, I can pair 2.115 and 2.130. I cannot pair 2.115 and 2.170 because it is not within the weight interval of +-0.030.
I needed help on how to formulate the formula.
A | B | C | D | E | F | G | |
Weight | 1.700 | 1.800 | 1.900 | 2.000 | 2.100 | 2.230 | |
1 | 1.710 | 1.710 | - | - | - | - | - |
2 | 1.700 | 1.700 | - | - | - | - | - |
3 | 1.680 | - | - | - | - | - | - |
4 | 2.040 | - | - | - | 2.040 | - | - |
5 | 2.170 | - | - | - | - | 2.170 | - |
6 | 2.115 | - | - | - | - | 2.115 | - |
7 | 2.130 | - | - | - | - | 2.130 | - |
8 | 1.840 | - | 1.840 | - | - | - | - |
9 | 2.240 | - | - | - | - | - | 2.240 |
10 | 2.100 | - | - | - | - | 2.100 | - |
11 | 2.140 | - | - | - | - | 2.140 | - |
12 | 2.000 | - | - | - | 2.000 | - | - |
13 | 1.800 | - | 1.800 | - | - | - | - |
14 | 2.100 | - | - | - | - | 2.100 | - |
15 | 2.245 | - | - | - | - | - | 2.245 |
16 | 2.115 | - | - | - | - | 2.115 | - |
17 | 2.130 | - | - | - | - | 2.130 | - |
18 | 1.825 | - | 1.825 | - | - | - | - |
19 | 2.225 | - | - | - | - | 2.225 | - |
20 | 2.160 | - | - | - | - | 2.160 | - |
<tbody>
</tbody>
Cheers,
blackorchids2002