Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Please Help, Need a Formula
Hi I have a spread sheet as per below:
What I need is a formula to search for a fund code from the top and from the bottom, if they match I need the Gain/Loss figures to be added together. Basically if any of the fund codes match in the upper portion with a fund code in the lower than add the gain or loss together to come up with the net gain or loss. If any of the cells within one range match any of the cells in the other add the applicable Gain/Loss together. Purchase Backdate or Redemption Cancel fund amount unit price price offset Gain/Loss FID235 NBC100 Purchase Cancel or Redemption Backdate fund amount unit price price offset Gain/Loss AIM1633 FID235 |