Hello,
Can someone help me to figure out a formula that find the closest match based on two criterias?
I have two sets of data. The date has to match each other in both sets. The amount may match, but can differ within +/- 10. I want to find the match or the closest match. How can this be solved? Example sets:
Set 1:
<tbody>
</tbody><colgroup><col><col></colgroup>
Can someone help me to figure out a formula that find the closest match based on two criterias?
I have two sets of data. The date has to match each other in both sets. The amount may match, but can differ within +/- 10. I want to find the match or the closest match. How can this be solved? Example sets:
Set 1:
Date | Amount | ||||||||||||||||||
02.06.2014 | 6 519 | ||||||||||||||||||
02.06.2014 | 15 741 | ||||||||||||||||||
02.06.2014 | 3 164 | ||||||||||||||||||
03.06.2014 | 29 756 | ||||||||||||||||||
03.06.2014 | 6 577 | ||||||||||||||||||
03.06.2014 | 15 741 | ||||||||||||||||||
06.06.2014 | 4 148 | ||||||||||||||||||
06.06.2014 | 12 949 | ||||||||||||||||||
Set 2:
<tbody> </tbody><colgroup><col span="2"></colgroup> |
<tbody>
</tbody><colgroup><col><col></colgroup>