P
Phillycheese5
Okay...I have a file with 2 data sheets, prior day PD and two days ag
2D. Each is a downloaded file containing portfolio holdings fo
multiple accounts, along with values. I'm trying to create a summar
page for each portfolio, and calculate the return. Each portfolio ha
about 70 stocks. Column A is stock name and B is account name. I wan
to use the account name as my reference to pull in data. How do I mak
a lookup formula when the value I'm looking up repeats itself? Then,
need to make sure the list of securities for PD and 2D are the same
even if there is a trade (i.e. for a buy on PD I would need to shif
down the dataset of 2D by one row). I'd like to put mismatche
securities at the end of the list. I'm lost as to how to attemp
that.
Any help or pointing in the right direction would be greatl
appreciated.
P.S. Data in the file for PD and 2D is identical
+-------------------------------------------------------------------
|Filename: Daily_Fixed_Returns_EF.zip
|Download: http://www.excelforum.com/attachment.php?postid=3522
+-------------------------------------------------------------------
2D. Each is a downloaded file containing portfolio holdings fo
multiple accounts, along with values. I'm trying to create a summar
page for each portfolio, and calculate the return. Each portfolio ha
about 70 stocks. Column A is stock name and B is account name. I wan
to use the account name as my reference to pull in data. How do I mak
a lookup formula when the value I'm looking up repeats itself? Then,
need to make sure the list of securities for PD and 2D are the same
even if there is a trade (i.e. for a buy on PD I would need to shif
down the dataset of 2D by one row). I'd like to put mismatche
securities at the end of the list. I'm lost as to how to attemp
that.
Any help or pointing in the right direction would be greatl
appreciated.
P.S. Data in the file for PD and 2D is identical
+-------------------------------------------------------------------
|Filename: Daily_Fixed_Returns_EF.zip
|Download: http://www.excelforum.com/attachment.php?postid=3522
+-------------------------------------------------------------------