Hi All... sitting at work trying to figure this out and have given up.
I have swaps on my books that have many difference legs, however, the end result are two offsetting swaps. each swap notional should be the same number. how can i create a formula to bring back the following:
Swap:
Deal number for Leg1: 12345.1
Deal number for Leg2: 12345.1
Deal number for Leg3: 12345.1
You can see that each leg has the same deal number. How can I match the deal number yet bring back only one value (I'm thinking maybe a max of the match of the arrary)? Keep in mind that there may be more than 3 legs so I can't just divide by three.
I've tried a =sumproduct(--(A2:A5=dealnumber),(max(A2:A5)), but that doesn't work.
Can someone please assist?
Much appreciated,
Brian
I have swaps on my books that have many difference legs, however, the end result are two offsetting swaps. each swap notional should be the same number. how can i create a formula to bring back the following:
Swap:
Deal number for Leg1: 12345.1
Deal number for Leg2: 12345.1
Deal number for Leg3: 12345.1
You can see that each leg has the same deal number. How can I match the deal number yet bring back only one value (I'm thinking maybe a max of the match of the arrary)? Keep in mind that there may be more than 3 legs so I can't just divide by three.
I've tried a =sumproduct(--(A2:A5=dealnumber),(max(A2:A5)), but that doesn't work.
Can someone please assist?
Much appreciated,
Brian
