Further to the answer below i am not quite clear how that answer sorts
an array. It appears to sort a range.

I have a similar problem:

How do i sort an array which contains 7 columns and 1,000,000 rows of
numeric data.
I bascially need to re-order the rows in ascending order based on the
value of the final column in the row.

eg.
1,1,2,3,4,6,99.78
2,3,4,5,6,1,12.34
2,1,3,4,2,2,10000.56
...

to give:
2,3,4,5,6,1,12.34
1,1,2,3,4,6,99.78
2,1,3,4,2,2,10000.56
...

How do i then take the top 50 rows into excel and delete the rest?

Thanks

N


---
Message posted from http://www.ExcelForum.com/