Creating a top five list from an Array

Hi folks,

I created an array of transactions from a dataset I have of over 5000 rows. The array works great to get the total transactions etc but I need to put the top 5 transactions (in terms of value) from this array into a table format. I will need two tables, one for Redemptions and one for subscriptions. The array element that determines if the transaction is a subscription or redemption is transarray(n,9) and the value of the transaction is stored in transarray(n,6)

I used the below code to get the top value but don't know how to the next four. Any help is greatly appreciated -

Please Login or Register  to view this content.