Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Matching data
Hi,
I need to build a system to monitor the 3 month rolling losers in my stock portfolio. I will be updating this worksheet on a weekly basis. I download all the required data for the two dates from a web based portfolio management system. Once downloaded and pasted into the same spreadsheet the data looks as follows: Date Stock Price Date Stock Price 22/03/2007 AAA $2 22/06/2007 AAA $3 BBB $10 CCC $5 CCC $4 EEE $7 DDD $2 FFF $3 EEE $9 GGG $4 FFF $3 GGG $1 I need to have the data in the 2nd stock column row match the stock data of the 1st stock column row. 22/03/2007 AAA $2 22/06/2007 AAA $3 BBB $10 CCC $4 CCC $5 DDD $2 EEE $9 EEE $7 FFF $3 FFF $3 GGG $1 GGG $4 Is there anyway for me to sort the data in this way? Thanks -- H |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I merge data in 2 sheets matching rows of data by last name? | Excel Discussion (Misc queries) | |||
Matching up data | Excel Worksheet Functions | |||
Is This Possible? - Data matching | Excel Worksheet Functions | |||
Matching data and linking it to the matching cell | Links and Linking in Excel | |||
Matching Data | Excel Worksheet Functions |