For Next with step
I have a spreadsheet with accounts which have stocks going from the
biggest negative change in value to the biggest postive change in
value. I need to get the top 5 of each (positive and negative) but one
account could only have 3 top and 2 bottom for example.
Sample:
Account Curr Stock diff
..
..
..
11200 JPY a 50
11200 JPY b 2000
11200 JPY c 3000
13400 GBP d -9003
13400 GBP e -653
13400 GBP f -23
13400 GBP g -2
..
..
..
In this example, account 11200 only has 3 top positive but 13400 has 4
top negative. I need to go down the list and get the info for all
accounts to a max of 5 top pos. and 5 top neg per account.
I would appreciate any help I could get on this issue.
Thx
Mat
|