View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mat Mat is offline
external usenet poster
 
Posts: 3
Default 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