All
First time on the site so appologies if I can find the answer elsewhere.
I have a many to many situation, that I am looking to resolve to give me one dataset. Any advice on formula/ add ins that can be used (cant code in VBA) would be appreicated.
Eg Two data sets of
<colgroup><col width="64" style="width:48pt" span="3"> </colgroup><tbody>
</tbody>
and
<colgroup><col width="64" style="width:48pt" span="3"> </colgroup><tbody>
</tbody>
Would want to expand the second data set to include every reinsurer for every contract and their share (which I would multiply by the amount).
Thanks,
First time on the site so appologies if I can find the answer elsewhere.
I have a many to many situation, that I am looking to resolve to give me one dataset. Any advice on formula/ add ins that can be used (cant code in VBA) would be appreicated.
Eg Two data sets of
Contract | Reinsurer | Share |
001X | Munich | 0.3 |
001X | Swiss | 0.6 |
001X | Lloyds | 0.1 |
002X | LLoyds | 0.2 |
002X | Muncih | 0.3 |
002X | RSA | 0.1 |
002X | Everest | 0.1 |
002X | AIG | 0.2 |
002X | AXA | 0.1 |
003X | RSA | 0.5 |
003X | AIG | 0.4 |
003X | lloyds | 0.1 |
<colgroup><col width="64" style="width:48pt" span="3"> </colgroup><tbody>
</tbody>
and
Contract | Risk Code | Amount |
001X | A | 1000 |
001X | B | 2000 |
001X | C | 2500 |
001X | D | 3000 |
001X | E | 4000 |
001X | F | 1500 |
003X | G | 10 |
003X | B | 1500 |
003X | F | 9000 |
003X | R | 10000 |
003X | T | 150000 |
002X | A | 150 |
002X | B | 1500 |
002X | C | 150000 |
<colgroup><col width="64" style="width:48pt" span="3"> </colgroup><tbody>
</tbody>
Would want to expand the second data set to include every reinsurer for every contract and their share (which I would multiply by the amount).
Thanks,