Modifiying Arrays

[ADE6]

Hi,

I have imported realtime currency prices into a spreadsheet using DDE links, if I have 5 rows showing the last 5 days prices the data is displayed with the most recent days record at the bottom of the table however I would like the most recent records to be displayed at the top.

ACTUAL RESULT
11/01/2007 1.9536
12/01/2007 1.9607
15/01/2007 1.9668
16/01/2007 1.9705
17/01/2007 1.9666

DESIRED RESULT
17/01/2007 1.9666
16/01/2007 1.9705
15/01/2007 1.9668
12/01/2007 1.9607
11/01/2007 1.9536

I have tried sorting the data by the date column, however because it is an array it will not allow this.

I know I could paste link each row into another area of the spreadsheet so as to invert the data and maintain the DDE links; this is fine if I only have a few rows but if there are hundreds then it is a bit time consuming.

I was wondering if there was a better method of inverting the data so that the most recent records appear at the top of the table.

Many thanks for the ideas.

Ade

 

[KenWright]

Could always just use the LARGE function (with the ROW function) to replicate the dates, albeit in reverse order, and then just VLOOKUP the relevant value for those dates.

Regards
Ken............

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------

 

[ADE6]

Thanks for the help Ken

Ade

 

[KenWright]

You're welcome - were you able to get there, or do do you need a hand still??

Regards
Ken........

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------