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.
[TABLE="width: 715"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Weight[/TD]
[TD]1.700[/TD]
[TD]1.800[/TD]
[TD]1.900[/TD]
[TD]2.000[/TD]
[TD]2.100[/TD]
[TD]2.230[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]1.710[/TD]
[TD]1.710[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]1.700[/TD]
[TD]1.700[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]1.680[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]2.040[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]2.040[/TD]
[TD]-[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]2.170[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]2.170[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]2.115[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]2.115[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]2.130[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]2.130[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]1.840[/TD]
[TD]-[/TD]
[TD]1.840[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]2.240[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]2.240[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]2.100[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]2.100[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD]2.140[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]2.140[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]12[/TD]
[TD]2.000[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]2.000[/TD]
[TD]-[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]13[/TD]
[TD]1.800[/TD]
[TD]-[/TD]
[TD]1.800[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]14[/TD]
[TD]2.100[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]2.100[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]15[/TD]
[TD]2.245[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]2.245[/TD]
[/TR]
[TR]
[TD]16[/TD]
[TD]2.115[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]2.115[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]17[/TD]
[TD]2.130[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]2.130[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]18[/TD]
[TD]1.825[/TD]
[TD]-[/TD]
[TD]1.825[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]19[/TD]
[TD]2.225[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]2.225[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]20[/TD]
[TD]2.160[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]2.160[/TD]
[TD]-[/TD]
[/TR]
</tbody>[/TABLE]
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.
[TABLE="width: 715"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Weight[/TD]
[TD]1.700[/TD]
[TD]1.800[/TD]
[TD]1.900[/TD]
[TD]2.000[/TD]
[TD]2.100[/TD]
[TD]2.230[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]1.710[/TD]
[TD]1.710[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]1.700[/TD]
[TD]1.700[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]1.680[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]2.040[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]2.040[/TD]
[TD]-[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]2.170[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]2.170[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]2.115[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]2.115[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]2.130[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]2.130[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]1.840[/TD]
[TD]-[/TD]
[TD]1.840[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]2.240[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]2.240[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]2.100[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]2.100[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD]2.140[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]2.140[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]12[/TD]
[TD]2.000[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]2.000[/TD]
[TD]-[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]13[/TD]
[TD]1.800[/TD]
[TD]-[/TD]
[TD]1.800[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]14[/TD]
[TD]2.100[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]2.100[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]15[/TD]
[TD]2.245[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]2.245[/TD]
[/TR]
[TR]
[TD]16[/TD]
[TD]2.115[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]2.115[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]17[/TD]
[TD]2.130[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]2.130[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]18[/TD]
[TD]1.825[/TD]
[TD]-[/TD]
[TD]1.825[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]19[/TD]
[TD]2.225[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]2.225[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]20[/TD]
[TD]2.160[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]2.160[/TD]
[TD]-[/TD]
[/TR]
</tbody>[/TABLE]
Cheers,
blackorchids2002